I have a loop that reads a text file and then archives it. I currently have
it skip the first line of the text file because the first line contains
summary information. But I would like the summary information to be included
in each line that I pull from the rest of the text file.

So I thought that if there is a way just to read that first line into a
Global Variable, then I could add that Global variable to the data
transformation before it get inserted into the table. Is this the way to do
it? If so how do I read the first line of a text file into a global variable?

Thanks, AshleyT

Assuming you are using File Sytem Object
find where the first VBCRLF is then read until there and that is your header
Put this in a global variable and add it to your transformation

http://sqlservercode.blogspot.com/

"AshleyT" wrote:

Hello AshleyT,

Then do just that. In an Active Script task open the file and get the first
line and store in a GV. You can use the FSO to do this.

Allan