regarding ssis - Read multiple excel sheets from one excel file

Hi,

We have 10 sheets in Excel File and 10 sheet contains errror data. How to load 9 sheets data in to 1 destination and error data in to other destination?


September 13th, 2015 1:49pm

You can use a Foreach Loop Container to loop to Excel sheets, but does the tenth sheet has a distinguishable name compared to the first 9?

Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 3:33pm

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

Other recent topics Other recent topics