Search code examples
ssismigrationssmsdtsssms-2012

Viewing DTS packages on SSMS 2012

We will be upgrading our SQL Server soon, but it is still using DTS components and thus I will be rewriting the packages so I can use all the new features of SSIS. I am trying to view the legacy DTS package in SSMS 2012 (I want to see what was previously done) but I simply cannot see them?

More info: I tried checking in the Management > legacy files and couldn't find anything.

Solution

  • Here is my solution to being able to view Legacy DTS components.

    1. Downloaded and install SSMS 2008 (install SP1 or higher) and choose the complete installation.
    2. Download the DTS and Backwards compatibility components https://www.microsoft.com/en-us/download/details.aspx?id=24793 I myself needed to install: SQLServer2005_BC_x64.msi (This is the backwards compatibility component for a 64 bit system.)
    3. Also select SQLServer2005_DTS.msi along with step 2 download.
    4. Once installed you should be able to view the Legacy components.

    Also, since I have been chasing this issue for a few days should I remember further steps that I took to install I will post here ASAP.