Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to load additional tab in Excel every month using SSIS Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 12:19 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:57 AM
Points: 93, Visits: 237
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


Post #1386704
Posted Tuesday, November 20, 2012 7:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:24 AM
Points: 2,818, Visits: 2,567
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.
Post #1386916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse