Hi All.
Got a bit of a problem.
Here's the scenario: we are extracting data from a SQL Server 2000 DB to a set of flat files, based on a date & sequence value held in a DIFFERENT database (also SQL Server 2000); and these date and sequence values have to be shown, by themselves, on the first line of the flat file.
I can get the date & sequence value fine via either a Lookup or global variables, and use them in the WHERE clause of a Data Transformation task to limit the data that is pulled to go into the output file; but I cannot get the Data Transformation Task to actually display those values in the file itself.
Does anybody know of a way to do this?
Thanx
David.