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.
| 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 Serverhttp://www.mssqltips.com/sqlservertip/2165/sql-server-2000-to-sql-server-2008-dts-package-conversion-runtime-issue/I basically run these: SQLServer2005_BC.msiSQLServer2005_DTS.msiThen 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 runSQLServer2005_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 |
 |
|
|
|
|
|
Legacy DTS package support