Post reply

SSIS - Insert Global Variable Into Table

  • June 20, 2013 at 6:09 am

    #395006

    I have a loop task in my ssis package, where I am reading a new file. The file name is being stored in a package global variable, then I load the contents into a table within a data flow task. My question is, how do I also load the file name global variable as part of each row being uploaded to the table?

  • June 20, 2013 at 7:09 am

    #1625889

    As part of the data flow in SSIS add a Derived Column task (image attached), inside that, give it a Derived Column Name, set it as a new column or an existing column and type the expression referencing the global variable (second image attached). Should be straight forward from that point

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

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