Posted: 8/24/2011
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.DLLfrom: %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn folderto: %ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
Copy RLLs SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLLfrom %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033to %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
Do you have a lot of activex script in that package? Have you used DTS exchange or run a DTSxchange profie using the profiler?