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 |
|
nathansneely
Starting Member
2 Posts |
 Posted - 2007-10-26 : 12:08:27
|
| I have been tasked with migrating/recreating our DTS packages from our old 2000 server to our all ready existing and in production 2005 server.I recently managed to create a simple SSIS package that connected to an Oracle database and dumped the data into the local MS SQL server. That is the extent of my knowledge of SSIS packages.I have done a little bit of research and so far it sounds like it will be a pain in the butt to do the migration.One thing I have read from a SAMS book is that migrating a DTS package that uses ActiveX will not work but then later on in the chapter it suggests that there is a possibility that migrating a DTS package that uses ActiveX could work. Which is it?Can someone give some general advice on how I should go about doing this? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 01:16:14
|
| We migrated same dts packages that use activex with wizard, worked so far. |
 |
|
|
ekb18c
Starting Member
18 Posts |
Posted - 2007-11-18 : 21:45:23
|
| If your DTS packages uses dynamic properties (among other things), then you will need to redo that step. When I migrated sql 2000 dts packages over to 2005, I ran into a few problems with converting dts to ssis.You need to evaluate which packages are important and which ones are not so important. So this is what I did. 1) I recreated some important dts packages over to ssis. Had to read up in the book and internet. (Works the best)2) Created a few hybrid SSIS packages. Used some components from older dts packages and combined with newer tasks on ssis. (One of them is ActiveX scripts)3) Created a SSIS package and used 'Execute DTS package' task. This works pretty damm good! I only used this for older DTS packages that I didn't want to "redo".Note: There is a patch you need to download in order to edit DTS packages in 2005. |
|
|
|
|
|
|
What to look for when migrating DTS packages?