SQL 2000 - The selected package cannot be opened - The DTS Designer has been closed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » SQL 2000 - The selected package cannot be...

SQL 2000 - The selected package cannot be opened - The DTS Designer has been closed

Rate Topic

Display Mode

Topic Options

Author

Message

melloman

Posted Tuesday, March 12, 2013 5:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 6:58 AM
Points: 3, Visits: 15

I have two SQL 2000 servers, Db1A and Db1B. There has been NO SQL 2005/2008 is or has ever been involved and in the past and has all be working fine, last week.

On Db1B I can use it's SQL Enterprise Manager and I can see both servers. I can also open up all DTS packages on both Db1A and Db1B, form the 'B' server. However on Db1A, I can open and edit some, of my DTS packages and not all of them. The DTS packages which fail on Db1A, all fail with this error:

"The selected package cannot be opened. The DTS Designer has been closed."

How can you fix it?

Post #1429700

EdVassie

Posted Wednesday, March 13, 2013 4:01 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 2,621, Visits: 2,759

Are you at the latest fix level? For SQL 2000 this is SP4 plus http://support.microsoft.com/kb/983811. However, I have no idea if this will solve your problem.

Try exporting the packages to a flat file. If you browse the files in Notepad you may spot something that seems to be wrong. After fixing the problem the package can be re-imported.

You can use native SQL Server DTS export functionality, or use DTS Backup 2000 http://www.sqldts.com/242.aspx to export and import the packages. DTS Backup 2000 has the advantage that annotations and the package layout diagram are preserved in the export/import, but not in the native DTS export/import.

This has just about exhausted my DTS skills, so if this does not resolve your problem then hopefully someone who knows more about DTS can help.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #1430277

« Prev Topic | Next Topic »

Permissions