none
SQL Server 2012 save SSIS package in MSDB

    Question

  • I am trying to save my package in MSDB database from SQL Server Data Tools 2012 (used to be called BIDS as you know). However, when I go to File --> Save mypackage.dtsx As, it only allows me to save it as File System, not in a SQL Server MSDB database! Is there a setting that I need to re-adjust? Thanks for your tip.
    Tuesday, September 04, 2012 3:40 AM

Answers

All replies

  • Hello,

    In SQL Server 2012 package are no longer stored in MSDB database, they are stored in a dedicated SSIS Catalog; have you set up this database? See Create the SSISDB Catalog


    Olaf Helper
    Blog Xing

    • Proposed as answer by Uri DimantMVP Tuesday, September 04, 2012 5:39 AM
    • Marked as answer by Peymaster87 Wednesday, September 05, 2012 3:47 AM
    Tuesday, September 04, 2012 4:54 AM
  • I did not know that. THANK YOU.
    Wednesday, September 05, 2012 3:47 AM
  • Olaf, thank you for that clarification and curing my headache.

    Unfortunately the documentation from MS is very confusing and options for 2008 are intertwined with 2012. For example when looking at http://msdn.microsoft.com/en-us/library/ms137731.aspx one starts reading about SSISDB, but the topics underneath that are mistitled and talks about backwards compatibility and MSDB deployment. The heading in the menu is titled "Manage the Integration Services Service" yet the title of the article is "Manage the Legacy Integration Services Service". The sections under http://msdn.microsoft.com/en-us/library/bb522537.aspx have (SSIS) in the title, but the one i mentioned above is referred to as (SSIS Service). This threw me for a loop of confusion and a half.

    Thursday, March 07, 2013 4:48 PM
  • I have configured the SSIS Catalog, and created folders.   However, I still do not get the option to to save to the catalog or server when I select 'Save Copy of Package As'.
    Thursday, May 15, 2014 4:15 PM