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

  • January 10, 2013 at 7:10 am

    #1575774

    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.