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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016
: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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