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 |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-08-16 : 11:43:07
|
| Hello - I currently have an SSIS package being built where I want to upload rows from an excel document into a Recordset Destination in SSIS. What I'm having trouble understanding is once the excel data is uploaded into the Recordset Destination how do I get that out and into two separate tables in my database with the data I want to query.If anyone can please provide me some direction I can research more from there. I'm a visual person if that helps :-)Thank you in adavance - David |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-16 : 14:47:06
|
| you need to use another data flow task which uses ADO.NET recordset as the source and then add your transformation based on business logic and finally oledb destinations for your tables------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Recordset Destination to SQL table?