Import data from multiple excel sheets to multiple tables using SSIS
August 25th, 2015 3:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics

Hi,

I have an excel file that has multiple sheets and I need to import data from each separate sheet to a separate table using SSIS. 
E.g. Sheet A data should go to Table A and Sheet B data should go to Table B and so on. 

Is it possible to do this with out using script task.

Can somebody help me to achieve this?

Regards,

Praveen C