March 12, 2013 at 5:38 am
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?
March 13, 2013 at 4:02 am
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: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply