Organising DTSX packages

  • richardmgreen1

    SSCrazy Eights

    Points: 9735

    Hi all


    We have a lot of DTSX packages in our solutions.

    For example, we have a MASTER package that calls other packages to do the actual work (and these may, in turn, call other packages to break the work down into smaller chunks).


    Unfortunately, all the packages in Visual Studio that appear  to be stored in alphabetical order (but not always).


    What we would like to do is to store the packages in folder to group them together .


    For example, we would have a "Level 1" folder with the Master package in it, a "Level 2" folder with the main set of DTSX packages, a "Level 3" folder and so on.


    I suppose we could rename the DTSX packages to start with the appropriate level number (or any other sort of marker) but my OCD is saying to store them in folders.


    Does anyone know if this is possible (it doesn't appear so at first glance) and, if so, how it can be done?





  • Phil Parkin

    SSC Guru

    Points: 243549

    Not possible, as far as I know. It's not the first time this question has been asked!

    You can modify the default order in which the packages are displayed by modifying the project file in a text editor, but that comes a poor second to the folder idea.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • ZZartin


    Points: 30338

    You can organize them in folder in MSDB or in the file system but not in VS sadly.

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

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