Trouble saving SSIS package in package store

  • I am trying to save a sql 2008 package (originally saved on the file system) into the SQL package store. This following article indicates I should double-click the package name under Solution Explorer, go to the File menu and use the "Save Copy of <package file> As." menu item. Well, that item does not appear under my File menu. Please advise.

    http://msdn.microsoft.com/en-us/library/ms137565.aspx

    TIA,

    barkingdog

  • Figured it out. Needed to import package under SSMS, Integration Services connection, not from BIDS directly.

    grrrrrr!

  • If you want to store SSIS packages in the MSDB folder from BIDS, install BIDS helper. It is free and extremely useful.

    Then you can deploy packages to MSDB with two simple clicks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply