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
Author
Message
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, March 13, 2014 5:26 PM
Points: 4, Visits: 20
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:50 AM
Points: 2,854, Visits: 3,174
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.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 29 May 2014: now over 29,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