Post reply

SSIS loading a flat file to sql server table Dynamiccally bcos the csv file colunm changes every month

  • May 26, 2015 at 2:46 am

    #308508

    Hi, I have a table of about 60 columns and at every given time I have to load flat file into this table, sometimes I get just 5 column to load, next month I might get 10 columns to load. Is there any way to dynamically map the flat file to the table. so that same ssis package can be use all the time. thank you

  • June 11, 2015 at 3:08 am

    #1804622

    I don't believe SSIS does dynamic imports. You could maybe use a script component to do so?

    LinkedIn

  • June 11, 2015 at 3:25 am

    #1804626

    There is no dynamic import of data....

    I was struggled the same for Siebel to SFDC of one of Data Migration Project.

    But you can try with SQL Commands..

  • June 11, 2015 at 10:52 am

    #1804780

    Thanks guys, I figure it out with the help of work colleague. I have a stored proc that read the first row of a csv file and load into temp table and then bulk import from second row into another temp table. This is then inserted into my staging table with max numbers of column. I can now map my staging to destination table.

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

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