Search results for query: *

All very useful stuff I am a bit restricted because I have no control over this server, the hosting service will not allow any modules on the server. The key I wrote works fine for this one but Millers script looks much better (thanks for spending the time) Kevin - thanks very much you too.

I was wanting to use UUID now I have given up on this one and I am building a string from Year,Month,Day, HH, SS, MM and IP address does this sound workable - the system will only be used by a few users and hardly ever at once !

Oh dear, they won't install it ! Any idea how I can easily create a sequence number without adding another module ? I want a unique sequence number from 0000001 and then in sequence to go in my file at the end of the rest of the data. Help !

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...

Surely someone knows a simple asnwer to this one ?

I have exactly the same problem, I would love to know why it won't accept 4 digit years

At Last I got this method working. What this does is enters address type records where they do not already exist in the destination table. THE LOOKUP TAB HAS THE FOLLOWING SELECT Address_Type_Code FROM ADDRESS_TYPE WHERE (Address_Type_Code = ?) THE ACTIVE X SCRIPT HAS THE...

At Last I got this method working. What this does is enters address type records where they do not already exist in the destination table. THE LOOKUP TAB HAS THE FOLLOWING SELECT Address_Type_Code FROM ADDRESS_TYPE WHERE (Address_Type_Code = ?) THE ACTIVE X SCRIPT HAS THE...

I have been playing with the Macro function and made some progress but not quite got the answer yet... The following looks OK, opens but does not accept / save my changes, obviously because no changes have been made when it opens, I think I am close please can anyone help ? Is there a on close...

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...

Thankyou very much, after posting this without reply I spent ages trying to find the file list and guess what, this was the one I found too.

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...

I am not sure how you mean by Taking DTS out of the mix, other than creating a holding table ? I really wanted to do this in one quick hit. I DID change the condition. I am pretty sure this and the other post is related I think I am doing something wrong on the lookup (on the connection)...

Thanks for the reply JB In fact I added a few more records and this actually crashes - I have no other problems but. After 1000 rows (and about 3-4 minutes) I get The number of failing rows exceeds the maximum specified Error Code:0 Error Source=Microsoft OLD DB Provider for SQL Server Error...

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...

Oh Nooooo I was wrong, it hasn't worked. I have zero records in my Table. Help !

What a complete star you are - I have been on this for ages. Top Man works spot on now ;-)

Wow That was a quick response. But I thought thats what I WAS Doing, could you please give me an example or more information Many Thanks Dave

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...