Post reply

Need to load additional tab in Excel every month using SSIS

  • November 20, 2012 at 12:19 am

    #285126

    Hi,

    Excel file has two tabs(Mon1 and Mon2) and i have loaded them into table by creating SSIS package.

    All the tabs have same column names and loaded into single table

    Next month, the excel file will have an addtional tab(Mon3) and need to load only the additonal tab(Mon3). Same way for the following months.

    Is there any way to load only the additional tab in SSIS?

    Otherwise we need to load all the tabs including the additonal tab.

    Please advise....

    Regards

    SqlStud

  • November 20, 2012 at 7:41 am

    #1560808

    If your tabs are consistently named you should be able to create a variable that uses an expression for its value. Create an expression that builds the appropriate tab name. When you are setting up your Excel source use a "Table name or view name variable" and then in the variable name use the variable you created above.

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

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