Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS in SQL 2005 - sort order of packages

Author  Topic 

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-06-06 : 07:43:21
Hi all,

I have just upgraded to SQL Server Management Studio 2005 on my computer and found myself working with old DTS-packages lately. To get it to work at all I had to install an extra something from MS which is working somewhat fine. But I'm having 2 problems:

1. Every time I want to edit an old DTS I get a list with a bunch of old versions with a timestamp for each one. The dates are in the format dd.mm.yyyy but the list is sorted alphabetically! This means that i.e. 15.05.2006 is after 01.06.2006 and this causes me some trouble when I have about 20 different dates and need to find the last one. How can I delete old packages or get the list to sort properly??

2. When I have found the right version and am in the process of editing it SSMS starts behaving quite peculiar...backspace suddenly doesn't work, typing doesn't work in some cases, and alot of other weird stuff happens. When I close the DTS everything is back to normal. Does anybody have a cure for this?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
   

- Advertisement -