Upgrade 2005 SSIS

[scottsanpedro]

Hi,
Just enquiring about upgrading from SQL Server 2000 to SQL Sever 2005 Workgroup edition.
I have a million and one DTS packages and am making sure that these will upgrade along with everything else normally.
Many thanks
Scott

 

[mrdenny]

You will have to run then through the upgrade wizzard and see what it does with them. If they are complex at all then you will probably need to manually convert them.

SQL 2005 does support DTS packages, but it is recommended that you convert them to SSIS packages as DTS will be gone in SQL 2008.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[katbear]

Depending on the complexity of the packages, it can take a long time to convert everything. I mean, days or months.

If you have any active x scripts, they can be wrapped up in "execute dts" tasks, but eventually they will have to be converted to vb.net script tasks if and when Microsoft decides to get rid of the "execute dts" tasks in future releases of ssis.

But you can take your time migrating.

 

[scottsanpedro]

many thanks for your answers. i will bear this in mind
Scott

 

[mrdenny]

Well the good news is that in the current beta release of SQL Server 2008 the Execute DTS task still exists. dtsrun also still exists, however you have to store the packages within the file system. The tables and procedures for DTS support do not exist within the SQL 2008 msdb database.

You even get a nice little error when you try to access Data Transformation Services in the GUI that says that it's not supported in version 10.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com