asked on

In SSIS, How to export an excel file by pointing to the specific tab # 3?

In SSIS, How to export an excel file by pointing to the specific tab # 3?

Source file has 3 tabs (or) 3 sheets. I need to export specifically sheet # 3 or tab # 3.
Sheet # 3 has few passages in the beginning and then comes table of records.

At present, I manually clean up the sheet # 3 by deleting the passages and having only the table of records.
I load the Excel by pointing only the sheet # 3 to the SQL Table.

slightwv (䄆 Netminder)

You should be able to use specific worksheets and/or named ranges.

Look in the section: In the SQL Server Import and Export Wizard

https://docs.microsoft.com/en-us/sql/integration-services/load-data-to-from-excel-with-ssis?view=sql-server-2017

Sharath S

Other option is, you can use Import/Export wizard to import the excel file. You can save that as SSIS package and use if you want to run that as an ETL process.

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-an-excel-data-source-sql-server-import-and-export-wizard?view=sql-server-2017

chokka

ASKER

My Challenge is mapping the SQL Table to the correct sheet ( Tab ) in the Excel.

Excel file comes with 3 tab / sheets. Out of 3, i need to pick the third one.

ASKER CERTIFIED SOLUTION

Sharath S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chokka

ASKER

Thank you Sharath .. We are using the Excel Source.

In the Property, I am setting the Sheet Name - Row # , Column #.