Post reply

ssis 2005

  • July 28, 2008 at 1:37 am

    #122606

    hi,

    i am using ssis 2005 . i have flatfile source and excel file source. from these file i am creating database, so that i have different table. in one table i need to put the name of source file from which i am inserting the datas. how can i dynamically identify and put the file name(eg: if i am using excel file then example.xls need to come in the last column of table in db) in table

    can any one help on this

    Thanks & Regards,

    Arun K

  • July 28, 2008 at 4:26 am

    #849048

    Are the file locations hard coded into the package? If so, I think you can use a script task to access the connections programmatically, and from there pull the filename.

    If not, grab the filename from the variable and add it in to the data flow using a derived column transformation.

    Also, if the filenames are hard coded, you may want to consider putting the filename and location into variables as this will improve the flexibility of your package.

    Hope this helps,

    Tom

    Life: it twists and turns like a twisty turny thing

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

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