October 3, 2014 at 12:56 pm
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
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.
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?
October 3, 2014 at 1:15 pm
From this article http://support2.microsoft.com/kb/2681562 it says that SQL 2005 is not compatible with Windows Server 2012. This could be the reason why you are having problems.
I know it's not a solution but do you have the option of upgrading your packages?
October 3, 2014 at 1:27 pm
I am running SQL Server 2008R2 Standard Edition - not SQL Server 2005.
SQLServer2005_BC.msi - Will not run on SQL 2012..
SQLServer2005_DTS.msi - Runs fine.
Does anyone know of a workaround or a different version of SQLServer2005_BC.msi ??
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply