SQL Server 2008 R2 Express Editon and old DTS packages

Question

Hi,

I need to know if it is possible to run and edit and old DTS 2000 pkg in a my SQL Server 2008 R2 Express Edition with Advanced Services.

Does it exist the corresponding version of the sqlserver2005_dts.msi file for SQL Server 2008 R2?

Many thanks

Answer 1

Hi, I've solved this issue in according with these links: http://www.bisql.net/2010/11/how-to-edit-dts-packages-in-sql-server-2008-r2/ and http://blogs.msdn.com/b/ramoji/archive/2008/10/16/how-to-open-dts-packages-in-sql-server-2008.aspx , thus

a) installing the Microsoft SQL Server 2005 Backward Compatibility Components, as a download comprises in the feature pack athttp://www.microsoft.com/en-us/download/details.aspx?id=16177 ;

b) installing the Microsoft SQL Server 2000 DTS Designer Components - sqlserver2005_dts.msi file (http://www.microsoft.com/en-us/download/details.aspx?id=15748);

c) ensuring that the PATH Environment Variable lists the SQL 2000 directory (e.g. ”C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\”) before the 2008 R2 one.

Thanks

Bye

Answer 2

Hi Pscorca,

I already installed sql server 2008 r2 backword compatibility components and sql server 2000 designer components, but still not able to run or modify dts packages.