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
source to share
No one has answered this question yet
See similar questions: