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 |
|
eugz
Posting Yak Master
210 Posts |
 Posted - 2012-03-19 : 16:13:57
|
| Hi All.Long time ago we start to use SQL Server 2000 and created some DTS. Now we got SQL Server 2008. My question is if I will create SSIS based on data from SQL Server 2000 does SSIS perform task faster then DTS with same data? Or I need migrate all data to new server and only by that way I will get faster SSIS execution.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-19 : 16:16:02
|
| it depends...Depending on how you implement it in SSIS, it can be faster than DTS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
eugz
Posting Yak Master
210 Posts |
Posted - 2012-03-19 : 16:21:00
|
| Thanks for replay.I thought create SSIS just by link each task to stored procedure located in old server.Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-19 : 16:31:36
|
| hmm..you've stored procedures already for task?then whats ssis package for?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
eugz
Posting Yak Master
210 Posts |
Posted - 2012-03-19 : 16:52:31
|
| How understand your last replay? You mean most correct way to create SP in new server based on data from old server? Can you explain detail what I need to do to create SSIS based on old data? Of cause if it is possible.Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-20 : 14:57:46
|
| it was a questioni was checking what stored procedures were forthen what was DTS package doing? just calling the procedures?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
SSIS based on all data