dbTalk Databases Forums  

Cannot Open/Run Packages on SQL Server 2000

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Cannot Open/Run Packages on SQL Server 2000 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kmole
 
Posts: n/a

Default 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!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.