how send data from excel to database using ssis package if i have 2 or more sheets in single excel file?

Question

how send data from excel to database using ssis package if i have 2 or more sheets in single excel file?

regards

samba

Answer 1

If all sheets have the same format then you can use a foreach loop.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter