Unable to Open DTS Package: "Unspecified Error"

[fuzzyocelot]

Hi everyone!

I have a DTS package in SQL Server 2000 that I wrote many months ago and have been modifying it every so often. This last week, our SQL Server dba was unable to open it. She received an error that just said "unspecified error". Nothing else! I have no problems opening it, though. We're trying to figure out why she can't open it. We both have Windows XP. She even tried to open it using the same login, tried it from the server itself, and she still couldn't open it. She can open the last version which was a couple of months ago but not the latest one. The only change I made to it was to an ActiveX script. She looked at the ActiveX script from my computer and couldn't see anything wrong with it. The package runs fine otherwise. The only difference we can see so far is that she has service pack 3 and I have 2. Also, I only have the client tools installed on my computer. She has a local instance of SQL Server 2000 on her computer. I recently installed SQL Server 2005 on my computer but I'm pretty sure I had made the change to the package using SQL Server 2000 before I installed 2005.

Does anyone have any ideas as to what may have happened and how we can fix this? I really appreciate any suggestions.

Thanks!

 

[gyfu]

Hey..
It could very well be the Service Pack issue. I have that same problem but once I get my service pack in sync with my colleague, it opens well.

It happen several times with various service pack.

Good luck.

-- gyfu --
Crystal Ver 10
Microsoft SQL

 

[ericarivera411]

Sorry guys but I am getting the same error, (Unspecified error) and I have service pack 2. So I don't think thats it.

Any more great ideas?
Thanks
Erica

 

[yagershot]

Does your DTS by chance have an FTP task in it? I was getting the same error (opposite - I couldn't open it after my dba modified it). When I removed the FTP task and replaced it with an Active X Script task that performed the same function, it worked. I don't know why I can't view DTS packages with FTP tasks created by my dba, especially since we are both doing it on the same server.