SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Read the data from Different format using SSIS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

210 Posts

Posted - 11/07/2012 :  05:43:59  Show Profile  Reply with Quote

Dear all,

my source data is existed in multipleExcel sheet in Single xl file.
1)excelfile is having 10 sheets,
2)exvelfile2 is having 6 sheets,
so i want to load this data in sql sever using SSIS(foreachloop)
how to load the all sheets data using ssis

anybody knows pls expalain me

Posting Yak Master

211 Posts

Posted - 11/08/2012 :  05:34:52  Show Profile  Visit prett's Homepage  Reply with Quote
Please follow procedure described in this article:
Hope it will help you!!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000