Re: EM crashes on open DTS package for Design No error
- From: Ed Enstrom <nospam@xxxxxxxxxxx>
- Date: Sat, 04 Nov 2006 16:40:45 -0500
cclements1384@xxxxxxxxx wrote:
Gurus,
Whenever I try to modify an existing DTS package on SQL 2000 SP4 the
Package does not open and Enterprise Manager closes after a brief
pause. There is no error is reported, either via pop up or in the
event log. I can't edit any DTS packages on this machine. Can anyone
offer any advice?
Chris
Do you have an FTP or custom task in the DTS package? I had the same problem that started after the October patches were installed. The XML patch may have done it. The cause was a DLL on my client machine did not match the one on the server. It was a newer version.
I had version 2000.85.1054.0 of C:\Program Files\Microsoft SQL Server\80\Tools\Binn\custtask.dll
I restored version 2000.80.760.0 and everything worked again. Note: EM opens the DLL, so you have to close EM in order to replace the file.
The most annoying part was that I had saved some packages while the 85.1054 version was on my PC. After restoring the 80.760 version, I could not open these. I had to put back the 85.1054 version, open the packages, remove the FTP tasks and save the packages. I then had to restore the 80.760 version, open the packages again, put back the FTP task and save once more. Thanks Microsoft!
Ed
.
- References:
- EM crashes on open DTS package for Design No error
- From: cclements1384
- EM crashes on open DTS package for Design No error
- Prev by Date: Help!! Trying to migrate data from one SQL to another?!?
- Next by Date: Re: newbie: SQL Agent Job Stopped working
- Previous by thread: EM crashes on open DTS package for Design No error
- Next by thread: Lineagefull??
- Index(es):
Relevant Pages
|
