Cannot Open/Run Packages on SQL Server 2000 -
12-08-2005
, 01:33 PM
Hello!
I am unable to run or edit any DTS packages on my SQL Server 2000 server
through Enterprise Manager. I receive the following errors:
Package Error
Error Source : Microsoft Data Transformation Services (DTS) Package
Error Description : Unspecified error
DTS Designer Error
The selected package cannot be opened. The DTS Designer has been closed.
I am able to update and run them from my development machine that recently
had VS 2005 installed with SQL Express. This machine now has version
2000.85.1054.0 of the DTSFFile.dll, DTSPkg.dll, and DTSPump.dll. The server
has version 2000.80.2039.0 of these files.
I was wondering if the SQL Express installation update these dlls, and if so
how can I update the DLLs on the SQL 2000 server (SP4) to these versions?
Also, will this fix the problem?
Thanks in advance! |