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

  • January 10, 2013 at 5:00 am

    #1575716

    Lidou123 (1/10/2013)

    Hi All,

    Please I need your help.

    I have an excel file File.xls that i want to load in a table TempTable. But my File.xls can have columns that change everyday.

    I think that If I create my table in runtime with the structure of the excel file, I will solve my problem.

    Please can U help me to create table dynamically with the same table structure that the columns of excel file.

    Thank U

    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?

    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.