Solved

SQL Server 2008 - Legacy DTS support

Posted on 2014-10-03
3
261 Views
Last Modified: 2014-10-09
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?
0
Comment
Question by:itsonlyme4
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40360380
C'mon, just rewrite the package already seems to be the best thing to do.
0
 

Author Comment

by:itsonlyme4
ID: 40362010
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.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 40362747
Have you considered installing the 64 bit version?  As in SQLServer2005_BC_x64.msi
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question