You may have noticed that Integration Service in SSMS 2005 does not list SSIS packages and Folders in any specific order. It’s random, most likely in the order we have added them in SSIS. Some times its very frustrating to search for a specific package or folder as the list is not ordered. Fortunately this issue does not exist with SQL Server 2008.

To fix this issue with SQL Server 2005, we need to alter two system SPs and these are msdb.dbo.sp_dts_listpackages and msdb.dbo.sp_dts_listfolders. 

 

 

Regards

Rakesh Mishra

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook