sql server dts: I have a fairly complex DTS Package written in SQL Server 2000, are there
any pointers in how to convert/upgrade this package to work with SQL Server
2005?

I haven't started the move yet, but want to be prepared.

Luis

Hi Luis,

I also had a fairly complex DTS package in SQL Server 2000, but I didn't
have any trouble running the same package in SQL Server 2005. I had to
install the SQL Server 2005 backwards compatability package as well as a the
SQL Server 2000 DTS Designer components (I supposed the designer components
are only necessary when you want to open/modify the package - not just for
executing).

If you want to convert the DTS package to a SSIS package though, that's a
different matter...


Regards,
Nils Magnus Englund

There is a wizard for doing the conversion if your package is saved in SQL
Server. Go to SQL Server Management Studio (SSMS), expand Management, then
Legacy folder, right-click on the Data Transformation Services folder and
choose Migration Wizard.

Any ActiveX scripts that use the GlobalVariables.Parent method will not
work. The Dynamic Properties task is no longer supported because there is
something called Package Configurations. You would have to re-implement these
bits using 2005 features.

Please note that the ActiveX script task has been retained in 2005 for
backward compatibility purposes. If you write any new script tasks, use the
Script Task.

Even if you successfully convert your DTS packages, you will probably
eventually want to re-write them from scratch to take advantage of SQL Server
Integration Services (SSIS).

Cheers,

Charles Kangai, MCT, MCDBA


[quoted text, click to view]