Setting a Global Variable from within a DTS Package

[MtProgrammer]

I have a DTS DataImport package that imports a text file into a table. The first record contained in the text file is not to be imported (works fine), but does contain a value that needs to be stored in all subsequent records. I'm not sure how to store this value in as a global and then insert it into every record after that. Does someone have an example?

 

[MDXer]

you could do 2 imports.

Import 1 - Import first row use an activeX transform and assign the value to a global variable.

2 Import - skip the initial row as you currently are and then in your transforms create a new transform of ActiveX type and assign the global variable to the appropriate column.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck