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 |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-03-26 : 14:21:31
|
| Join multiple files, do a lookup to another file and then extract the results to a staging table? can it all be done in one execute SQL statement in the data flow (where is execute SQL in the dataflow???, i cant find it) and then a lookup transformation followed by copying the results to the destination of the data flow? |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-27 : 09:22:20
|
| =>You can join file susing the Merge Join function.=>Execute SQL will be present in the COntrol flow. For you scenario below..you can first have a Data Flow Task with the Merge Join and then have a OLE DB destination to upload the file onto a table. |
 |
|
|
|
|
|
in SSIS what is the simplest way to...