Blank DTS Packages in Designer

  • Randomly when opening DTS packages in the Designer in SQL 2000, the packages are empty, blank screen. If you open and close several times eventually the package details appear. This also happens with the scheduled job where occassionally it fails with an error regarding zero rows of instructions.

    We did not see any locks or blocks on the msdb database. This happens with all packages. The package may open correctly the first time or you might have to try 5 times to get it to appear.

    Restarting the server appears to clear it up temporarily.

    Thanks for any suggestions.

  • Check out this post: http://www.sqlservercentral.com/Forums/Topic364780-5-1.aspx

    I would try adding some additional free space to the msdb database to see if that resolves the issue.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply