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

All Articles