itsonlyme4
asked on
SQL Server 2008 - Legacy DTS support
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\VSSh ell\Common 7\IDE folder.
2.Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\Resou rces\1033 folder to
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSSh ell\Common 7\IDE\Reso urces\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?
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\VSSh
2.Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\Resou
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSSh
-----------
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?
C'mon, just rewrite the package already seems to be the best thing to do.
ASKER
We have around 30 rather complicated packages - most of which are due to be retired within the 60 months or so the rewrite effort for the App Dev guys is not worth the effort at this time. The alternative is to switch back to a Windows 2008 Operating System so I can bring the packages forward to SQL Server 2008 but I was hoping to get this all to work on a Windows 2012 OS.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.