Search results for query: *

Reading various articles I now know I want to create a UUID variable within my existing form script. Can anyone tell me where to find an idiots guide to UUID ? I have some examples and I know what I need to add to the script, my problem is that I don't now how to install the module. This is...

I am not sure if this is possible but here goes Word 2000 Document with Form Single Record Mail Merge (toggled to view on screen) I want to track changes AFTER the record has been toggled, not to view the changes but save/accept the changes when saved. The idea is that I want the users to...

Hi I want to be able to allow users to call DTSRUN from within my utility (this is a small application to pass data to a master SQL 2000 database from a Laptop) All I really want to do is find out which files I need to copy to my Laptop. I have read that the DTSRun is Runtime Royalty free and...

Hope someone can help me. I started to play with ActiveX VB Scipts last week and had some good success but the lookups are really causing me problems, I am sure I am missing just one simple thing but I just can not find it. These two posts remain un-resolved...

I have been getting nowhere with this one, please can anyone help, NPC_Code is the PK in a table called STOCK I have a Lookup SELECT NPC_Code FROM STOCK WHERE (NPC_Code = ?) And Then Trying to use this within the script Function Main() Dim tNPC tNPC =...

This is my first attempt at a VBScript within a DTS package but it is far too slow. What I am trying to do is insert around 3Million records and Lookup a couple of values at the same time. My thinking was that this would be faster but it does not seem to be the case. I have two lookups the...

Following on from a previous post(http://www.tek-tips.com/viewthread.cfm?qid=1138954&page=1 ) This is my first experience using VBS with DTS, I have the following Scipt within my DTS Package. Dim tSeq Dim tCleanSeq Function Main() tSeq = tSeq + 1 tCleanSeq = Right("0000000" & tSeq, 8)...

I am using SQL 2000 and have used the DTS to do straight import / exports for some time now. Now have a massive data set that I need to import (5 Million records), the trouble is it needs cleaning, in the past I would insert to a Dummy SQL Table and write a TSQL Script to clean it. Now I would...

Hi, I am pretty new to SQL (MSQL 7). I have been writting various triggers to flag data upon insert etc, however I do not really know where to start with the following.. I want a script to check for a record existing in a table and if it exists update the contents, if it does not, create a new...

Hi I am using Server 7 I am looking for what you guys may think is a very simple trigger, (I am at the bottom of a big hill and need help climbing!) I want to be able to record the Date / Time a record was created and the user who created it. I also want to record the last update Date /...