Stand alone viewer for DTS packages
Posted on 2013-12-10
I have SQL Server 2008 and 2012 on my box at work. We're trying to upgrade one of our SQL Server 2000 suite of databases to 2012. I have been asked to document various DTS packages. I do not need to change them, just look at them. I'm running Windows 7 and there is a SQL Server 205 DTS designer from Microsoft, along with a backward compatibility iinstall which if I understand things correctly, will allow me to look at DTS packages in SQL Server 2008 Studio Manager. But the backward compatibility won't install on Windows 7. My question is this. Is there a stand alone DTS viewer? As I don't need to execute or modify them, I just want to see them. DBAs have exported DTS packages to DTS files with the .dts extension so I want to open up those files and have a look. I don't have access to msdb so it looks like I am stuck with the .dts files.