Home Forums Data Warehousing Integration Services Help !! Create dynamically table destination RE: Help !! Create dynamically table destination

  • January 10, 2013 at 7:15 am

    #1575781

    Lidou123 (1/10/2013)

    Phil Parkin (1/10/2013)

    Lidou123 (1/10/2013)

    Hi All,

    Very difficult - SSIS is meta data driven and changing meta data gives it a severe headache.

    Also, if your columns change every day, how will you know which columns to map them to on TempTable? Is the structure of TempTable changing too?

    Hi Phil,

    Thank You for your answer !

    Yes the structure of TempTable change too.

    The columns of the TempTable are same that the columns of the Excel File.

    So the temp table needs to be dropped and recreated everytime the import runs, based on the contents of the Excel file.

    There's no way I can think of doing this using standard SSIS components. If I were you, I would probably craft a fully scripted solution in a C# script task (after checking Google to see whether anyone else has already done it another way).

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.