How to read excel sheet name Dynamically in SSIS .and use it in excel source.

Question

How to read excel sheet name Dynamically in SSIS .and use it in excel source.

Earlier I was using OleDbConnection

connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilepath + ";Extended Properties="EXCEL 12.0 XML;HDR=YES;IMEX=1"");

I have migrated my application to Visual studio 2022 and here

connection.Open();

raising an exception .

Please give a solution how to read excel sheet name Dynamically in SSIS

Answer 1

Hi @LOUIS Lini (SAFRAN ENGINEERING SERVICES)，

You may need to use Script Task to do that.

Please refer to below links for the steps.

Dynamic Sheet Name in SSIS Excel Spreadsheet imports

Import data from Excel using SSIS without knowing sheet name

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.