Question Locked

SQL Server Management Studio Express and Backwards Compatibility

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I downloaded the SQLServer2005_DTS.msi install and ran it on a workstation that has Microsoft SQL Server Management Studio v.9.00.1399.00
installed and I was able to see the legacy Sql Server 2000 packages on another server. Works Great! My Issue is when I try to install DTS Support on a workstation that has Microsoft SQL Server Management Studio Express v.9.00.2047.00 only, i do not see the legacy dts packages from the 2000 server. Has anyone had any success using SQL2005MMS express and the SQLServer2005_DTS.msi (or the SQLServer2005_BC.msi (Backward Compat)) to work?

BTW This was what I was missing to manage the 2000 servers i have and it works fine from the machine I have 2005 server installed..

2 replies

by tony hopkinson

As far as I remember you could could use a wizard to export them to the new format. But the wizard is apparently iffy on complex packages, the other method was to execute them with the DTS package run time tool. That was pretty much it.

This discussion is closed to new replies.