I am able to convert the excel file sheet to CSV by using script task but my all Excel sheet is getting converted to CSV.So I need a single sheet to convert to CSV.
Asked
Active
Viewed 18 times
0
-
Why don't you just connect to the excel file directly from SSIS using the Excel Connection? – iamdave Nov 30 '21 at 11:08
-
It is well-nigh impossible to debug code without seeing code – billinkc Nov 30 '21 at 15:34
-
Here's a hint use OleDB and write a SQL statement. The "table" in SQL is the SheetName. – KeithL Dec 01 '21 at 14:30