Running DTS package in sql server 2008

Who is online?  0 guests and 3 members
Home  »  Forums   »  bidn   »  general bi discussion   » Running DTS package in sql server 2008

Running DTS package in sql server 2008

Topic RSS Feed

Posts under the topic: Running DTS package in sql server 2008

Posted: 8/24/2011

Jedi Youngling 20  points  Jedi Youngling
  • Joined on: 2/25/2011
  • Posts: 10

When I tried to run the DTS legacy package in SSMS 2008, and I tried to open  a lookup, the screen freezes and I do not even get an error message. It just won't work and I have to kill the process.

The screen shots look like this:

http://www.bidn.com/Assets/Uploaded-CMS-Files/dtsIssue-7d84df39-2c64-466c-aed1-ef66c5cd2fc5.jpg

http://www.bidn.com/Assets/Uploaded-CMS-Files/dtsIssue2-7f700b67-302d-4e77-ba87-24aafabe0dce.jpg

The same error occurs when I select build query in the transformation source.

My system information and other details:

OS: Window Server 2008 Enterprise without Hyper-V Service Pack 2

SQL Server: SQL Server 2008

CPU: 32 bit

I have both of these installed:

 Microsoft SQL Server 2000 DTS Designer Components 
 Microsoft SQL Server 2005 Backward Compatibility Components

 It is still not working.

I also did the following:

Copy  SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL
from: %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn folder
to: %ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

Copy RLLs SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL
from %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033
to %ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033

Reboot

I would really appreciate it if I can be advised as to what to do next or what I was missing?

Thanks,

SMP


Posted: 8/28/2011

Padawan 734  points  Padawan
  • Joined on: 6/6/2011
  • Posts: 42

Do you have a lot of activex script in that package? Have you used DTS exchange or run a DTSxchange profie using the profiler?


Page 1 of 1 (2 items)