Need to load additional tab in Excel every month using SSIS

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  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

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  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.