how to import data from Excel sheet to SQL Server using SSIS by counting through the number of sheets

tags:

ssis

views:

412

answers:

+1 Q:

how to import data from Excel sheet to SQL Server using SSIS by counting through the number of sheets

Hi,

I am doing an application where in I have to import data form excel workbook having multiple sheets and the count of the shets is not known exactly and I need to get the data from these multiple sheets to the SQL Server.I need to do this using SSIS.

Please help me out.....

Thanks in Advance...

These articles will help you to do http://blogs.techrepublic.com.com/datacenter/?p=205 http://www.mssqltips.com/tip.asp?tip=1393

valli 2009-11-20 09:38:13

Thanks For the reply..but What I need is I may have multiple sheets in a single work box and I need to import these multiple sheets to he SQL Server...hope you understand my question....Thank You...

Reddy 2009-11-20 12:44:59

Here is what you are looking for: http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx link text

rfonn 2009-11-21 05:12:18

Thanks for the reply...I hope the solution is perfect but I am encountering with errors while executing the package.I am getting errors at FOREACHLOOP...I hope it is not properly taking the worksheet values...Please if you are able to execute the package please let me help it out as I am in urgency in executing this task...Thank You Once Again..waiting for your help....

Reddy 2009-11-21 09:46:30