Post reply

SSIS variable added to import file

  • April 16, 2010 at 9:24 am

    #144113

    I am new to SSIS and I have created a package that loops through files in a directory and imports them into a table. The package works fine but I would like to add the file name that the data came from and add it to a column in the import file or into the table that it was imported into. I have tried adding a derived column but cannot seem to get the value from the variable into it.

  • April 16, 2010 at 12:09 pm

    #1153053

    A derived column is the right path. What are you using to loop through the directory? A For-Each-Loop?

    Also, why don't you add a data-viewer to see what is in the pipeline immediately following the derived column task.

    CEWII

  • April 16, 2010 at 4:44 pm

    #1153205

    I was able to finally get it to work. I had to Cast the variable and allow for a longer string. Thank you for your suggestion.

  • April 16, 2010 at 7:07 pm

    #1153246

    Wonderful, glad to hear it..

    CEWII

  • April 21, 2010 at 10:24 am

    #1155490

    bob_kudulis (4/16/2010)

    I am new to SSIS and I have created a package that loops through files in a directory and imports them into a table. The package works fine but I would like to add the file name that the data came from and add it to a column in the import file or into the table that it was imported into. I have tried adding a derived column but cannot seem to get the value from the variable into it.

    Check this post.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 5 posts - 1 through 4 (of 4 total)

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