Post reply

Displaying global variables/lookup values in flat file output

  • August 23, 2006 at 3:29 am

    #67634

    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.

  • August 24, 2006 at 7:36 am

    #656564

    Have you tried to write the first line of the export file from the step where you select the global variables and then append the other records to the same file?

    So you would select your global variables, create a text file and write the global variables, then select your data from the other server.db.table and append these rows to the existing text file.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply