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.
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.