how to resequence order of ssis packages

Question

Post reply

how to resequence order of ssis packages

Richard Cranston

Hall of Fame

Points: 3680
More actions
June 3, 2008 at 7:45 am

#124008

I would like to resequence the list alphabetically. When I drag the package to the bottom, it appends a version to it and then I end up having to rename it.

Viewing 9 posts - 1 through 8 (of 8 total)

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

Jim SSCrazy Eights Points: 8720 More actions · Answer 1

Where are you trying to resequence the order of the packages?

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 2

I will probably have about 50 to 60 packages and it will make it a lot easier to find the package if it is alphabetical.

Also, this will group my packages. Example Lkp_Design_Layout, Lkp_Desing_Motif, etc....all these LKP_Design would be together.

Jim SSCrazy Eights Points: 8720 More actions · Answer 3

Sounds like a logical way to group them. Where are you trying to accomplish this? Are you viewing them in SSMS (connected to the SSIS server), file system, Solution Explorer in BIDS?

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 4

Using Sql Server Business Intelligence Development Studio, Integration Services Project. Packages are created/stored using the File Server.

Jim SSCrazy Eights Points: 8720 More actions · Answer 5

I'm not seeing a way to order them in BIDS. I do see what you are talking about when you try to move them around to order them manually. Seems like a design flaw.

As far as the file system is conerned, it should order them automatically.

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 6

Yeah, I've been asking MS for package sorting for 3yrs.

And it doesn't look like it was a priority in Katmai either.

Watch my free SQL Server Tutorials at:

http://MidnightDBA.ITBookworm.com

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

bmcclain Old Hand Points: 326 More actions · Answer 7

There isn't an automated way to resequence the packages in BIDS, but you can do it manually. In the project folder containing your packages is the projectname.dtproj file. This xml file contains the metadata describing the project. If you open it with NotePad, you will see a bunch of DTSPackage tags within the DTSPackages tag. You can reorder the DTSPackage tags however you want. When you reopen the project in BIDS, that order will be respected.

You can also order the packages within SSMS when you deploy them to your server by rearranging the Package tags in the projectname.SSISDeploymentManifest file that is created when you build your project.

Hope this helps,

Bryan

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 8

Thanks, doing the manual edit on the xxx.dtproj file worked just fine for me...very nice...thanks again.