Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL 2000 - The selected package cannot be opened - The DTS Designer has been closed Expand / Collapse
Posted Tuesday, March 12, 2013 5:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:24 AM
Points: 4, Visits: 21
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
Posted Wednesday, March 13, 2013 4:01 AM


Group: General Forum Members
Last Login: Yesterday @ 10:16 AM
Points: 2,952, Visits: 3,463
Are you at the latest fix level? For SQL 2000 this is SP4 plus 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 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.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 23 July 2015: now over 34,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 »

Add to briefcase

Permissions Expand / Collapse