How to pass excel sheet dynamically to excel source in ssis

Sorry if the question has already been asked

I am new to ssis. I have a situation like my package needs to dynamically fetch excel files and load them into a database. So far I've created a package for this and set a variable to dynamically select a file like ...

Variable name: File_Path; Scope: Package; Data type: String;

Value: C: \ Today_IMPORT \ New_Folder \ calculate.xlsx

But the problem is my excel sheet calculate.xlsx contains 4 sheets in it: Sheet1, Sheet2, Sheet3 and Sheet4 , my excel source has to select Sheet2 every time my batch is running. I tried setting the variable value to C: \ Today_IMPORT \ New_Folder \ calculate.xlsx \ Sheet2 but it doesn't work ...

Help me with this

Thank you in advance

+3
excel ssis


source to share


No one has answered this question yet

See similar questions:

1
Hidden SSIS sheets as Excel destination

or similar:

1786
How to create Excel file (.XLS and .XLSX) in C # without installing Microsoft Office?
2
How to recover sheet name in Excel
2
Excel dynamic tables are loaded into SQL using SSIS
1
Excel dynamic worksheet reference
1
SSIS - extract sheets from latest excel file to folder
0
How to dynamically set DataFlowTask: Excel source in SSIS package?
0
How to INNER JOIN in SSIS Excel source code component
0
How to combine multiple Excel sheets into one Excel sheet using VBA
0
How to import multiple Excel sheets from Excel source to SQL using SSIS?
-1
encrypt excel special sheet



All Articles
Loading...
X
Show
Funny
Dev
Pics