locked
SSIS package storage locations - what's the difference between SQL Server and SSIS Package Store? RRS feed

  • Question

  • What is the "SSIS package store" and how does it differ from the other two storage options, "SQL Server" and "File System"?

     

    Tuesday, January 11, 2011 9:46 PM

Answers

  • Hi,

    The SSIS Package Store is a nice option to available for storing SSIS packages.  The Package Store list packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008) in the File System folder.

    It is possible to adjust the Package Store to look for packages in different file system folders or different server instances.  To do this you must change the MsDtsSrvr.ini.xml file in the C:\Program Files\Microsoft SQL Server\100\DTS\Binn (folder is in SQL 2008 only). 

    It’s a pretty simple change that you can even use notepad to do.  Here are the steps to follow to add a new File System folder to the Package Store.

     

    Let me know if you have more questions.


    Please mark as answer if this helps. Thanks. :-)
    • Proposed as answer by SaeedB Wednesday, January 12, 2011 4:04 AM
    • Marked as answer by MGS66 Tuesday, January 18, 2011 8:33 PM
    Wednesday, January 12, 2011 4:04 AM

All replies

  • What do you mean from the SSIS package store?

    When we connect to SSIS service via SSMS, what we get to see is 2 way to stre packages

    1. File System:- this is for the packages which have been stored physically on the drive, thi can be anywhere on the drives

    2. MSDB: these are the packages installed on the system and cna be ran instantly, these are the ones which are stored inside the pace allocated by the INtegration services for its things,

    Tuesday, January 11, 2011 9:55 PM
  • What do you mean from the SSIS package store?

    When we connect to SSIS service via SSMS, what we get to see is 2 way to stre packages

    1. File System:- this is for the packages which have been stored physically on the drive, thi can be anywhere on the drives

    2. MSDB: these are the packages installed on the system and cna be ran instantly, these are the ones which are stored inside the pace allocated by the INtegration services for its things,


    Visual studio gives you three location options to choose from (a drop-down list box) when you add an existing package to an SSIS project: 1) File System, 2) SQL Server (which is what you are calling msdb), and 3) SSIS Package Store. You can see this for yourself by following these steps:

    1. Using the BI development tool (Visual Studio) create or open a BI project solution for Integration Services

    2. In the Solution Explorer window, right click on the SSIS Packages folder. Choose add existing package. This pops up a window with a drop down list box of locations to search for the package to be added.

    Tuesday, January 11, 2011 10:49 PM
  • Hi,

    The SSIS Package Store is a nice option to available for storing SSIS packages.  The Package Store list packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008) in the File System folder.

    It is possible to adjust the Package Store to look for packages in different file system folders or different server instances.  To do this you must change the MsDtsSrvr.ini.xml file in the C:\Program Files\Microsoft SQL Server\100\DTS\Binn (folder is in SQL 2008 only). 

    It’s a pretty simple change that you can even use notepad to do.  Here are the steps to follow to add a new File System folder to the Package Store.

     

    Let me know if you have more questions.


    Please mark as answer if this helps. Thanks. :-)
    • Proposed as answer by SaeedB Wednesday, January 12, 2011 4:04 AM
    • Marked as answer by MGS66 Tuesday, January 18, 2011 8:33 PM
    Wednesday, January 12, 2011 4:04 AM
  • Hi,

    In other words, "SSIS Package Store" is used to connect to a SSIS server, and "SQL Server" is used to connect to a SQL Server.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, January 13, 2011 10:00 AM