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 |
|
BhaskarDasari
Starting Member
19 Posts |
 Posted - 2008-03-26 : 09:12:00
|
| Hi,I am going to work on the Migration project(DTS to SSIS).Could you plese suggest me some useful links reg Migration process and Best Practices used for Migration.Appreciated Assistance/guidence in this regard |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-26 : 09:55:32
|
| Use DTS migration Wizard in BI |
 |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2008-03-26 : 11:56:19
|
| I would not recommend using the wizard. All the wizard does is export your DTS package, and then creates an SSIS package to execute the old DTS package which is embedded inside the SSIS package file.The best way is to manually redevelop the package using the new SSIS objects.- Eric |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-26 : 12:38:46
|
| Did you read carefully what i have written. I am saying just migrate from DTs to SSIS BI. You can manually change connection strings and redevelop in BI and then deploy it to the server or jobs. |
|
|
|
|
|
|
Migration From sql server 2000DTS to SSIS