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 |
|
Chris_Kelley
Posting Yak Master
114 Posts |
 Posted - 2014-09-17 : 00:33:15
|
| c |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-17 : 07:48:56
|
| With SSIS, you may be able to bypass the temp table which may decrease runtime. Its easy to set up a test case to confirm or refute that theory. I'd say give it a try. |
 |
|
|
Chris_Kelley
Posting Yak Master
114 Posts |
Posted - 2014-09-17 : 09:49:56
|
| c |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-17 : 11:27:32
|
| You'll need to use BIDS (SQL SERVER 2008 and below) or SSDT (2012 and up) to use the full power of SSIS, including data mapping. |
|
|
|
|
|
|
SSIS..?