asked on

VBScript Creating Record Numbers from a Text File Import

I am creating a fairly simple DTS package (using VBScript) that will take a file that was FTP'd from a vendor site once a month. Then this file will be imported into a staging table so our Accounts Rec person can process it. There is a place for a sequence number and I want to put in a record number for the import. I am clueless on how to generate this on the fly while processing records.

Thanks

Bill

SOLUTION

knucklesbamm

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

blouckswwu

ASKER

Sorry for the delay in responding to this thread. Due to lack of knowledge on DTS (outside of the wizard), I've been trying to read about Global Variable's in DTS. I am having a hard time finding information about this on the Internet that would have a good coding example of how to go about creating and using a Global Variable. Can you give me a little direction?

Thank you!

Anthony Perkins

>>Can you give me a little direction?<<
I believe I did. I any case please take a look at the following site:
http://www.sqldts.com

And in particular the following links:
Introduction To Global Variables
http://www.sqldts.com/default.aspx?280

blouckswwu

ASKER

Then let me restate my statement: "Can you give me a little more information?"

The links was what I was looking for.