How to add new package store under Stored Packages

 

In order to create a new folder called ‘My Packages’

1. Find the file called MsDtsSrvr.ini.xml in C:\Program Files\Microsoft SQL Server\100\DTS\Binn

2. Use a notepad and add the code in underline. Also make sure folder does exist. In this case c:\SSIS does exit.

 

3. Save and make sure you restart SSIS engine via Sql Server Configuration Manager

 

<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
  <TopLevelFolders>
    <Folder xsi:type="SqlServerFolder">
      <Name>MSDB</Name>
      <ServerName>.</ServerName>
    </Folder>

    <Folder xsi:type="FileSystemFolder">
      <Name>File System</Name>
      <StorePath>..\Packages</StorePath>
    </Folder>

    <Folder xsi:type="FileSystemFolder">
      <Name>My Packages</Name>
      <StorePath>C:\SSIS</StorePath>
    </Folder>

  </TopLevelFolders>
</DtsServiceConfiguration>