Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Legacy DTS package support

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2014-10-03 : 15:29:55
I found a way (at this link) to be able to run my Legacy DTS packages in SQL Server 2008 r2 on a Windows 2008R2 Server
http://www.mssqltips.com/sqlservertip/2165/sql-server-2000-to-sql-server-2008-dts-package-conversion-runtime-issue/

I basically run these:
SQLServer2005_BC.msi
SQLServer2005_DTS.msi

Then copy some files:
1.Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn folder to
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.

2.Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\Resources\1033 folder to
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033 folder.
-----------

Now I am trying to do the same thing except on a Windows 2012 Server.
I installed SQL Server 2008 R2 on my WINDOWS 2012 Server.
I am able to run SQLServer2005_DTS.msi (SQL Server 2000 DTS Designer Components) but when I attempt to run
SQLServer2005_BC.msi I get an error saying it is not supported on this operating system -

can anyone help or shed some light?


gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-03 : 15:56:40
You have to upgrade your packages
Go to Top of Page
   

- Advertisement -