Rearrange SSIS Packages in SSIS Project.

If you create multiple packages in a Project, SQLServer Business Intelligence will not sort them based on file name. 

There is an alternate way to sort the items in the way you need.

Open .dtproj file in Notepad / Notepad ++ 

Scroll down to <DTSPackages>

Example :

 <DTSPackages>

    <DtsPackage>

          <Name>20-Export-To-Production.dtsx</Name>

          <FullPath>20-Export-To-Production.dtsx</FullPath>

          <References />

    </DtsPackage>

    <DtsPackage>

      <Name>10-Import.dtsx</Name>

      <FullPath>10-Import.dtsx</FullPath>

      <References />

    </DtsPackage>

  </DTSPackages>

You will see XML elements with SSIS package names. Cut and paste them in the order you want and save the .dtproj file.

   <DTSPackages>

    <DtsPackage>

      <Name>10-Import.dtsx</Name>

      <FullPath>10-Import.dtsx</FullPath>

      <References />

    </DtsPackage>

    <DtsPackage>

          <Name>20-Export-To-Production.dtsx</Name>

          <FullPath>20-Export-To-Production.dtsx</FullPath>

          <References />

    </DtsPackage>

  </DTSPackages>

Make sure you are cutting and pasting them with opening & closing tags.

Close Notepad.

Open your Project using Sqlserver Business Intelligence Studio

You will see the packages rearranged in desired sequence.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: