Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bfunny21
Starting Member
4 Posts |
 Posted - 2010-09-07 : 10:44:02
|
| Hi AllI want to extract data from multiple Excel sheets and then create different tables for that data in the SQL server and load that data into the respective table. I want to do this using SSIS. I know we can do this by creating separate package for each file but is there any way we can do this operation in a single package?Looking for this type of solutionFile1 ---extract data--> SSIS -createtablewithvar-->SQLSERVER tab 1 | | File n tab n Thanks in advance.... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-23 : 13:31:06
|
| you can . But you need to use a for each loop to loop through excel files and inside add a script task. Inside script you need to create an object of data flow task with excel source and oledb destination. then add required mappings and it will automatically run for all files loading data to corresponding tables.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS Scenario