Post reply

msdb

  • December 21, 2009 at 8:53 am

    #141172

    Hi

    i have a ssis package which stored in ssis package store . i need to save the package in msdb.

    I have few packges which are stored in filoe system how do i change it to ssis store

    I am pretty new to this stuff

    how do i save it plz help me ?

  • December 21, 2009 at 8:59 am

    #1094821

    To save packages in the MSDB;

    on the package click Save Copy of Package as --> then enter your server details..

    make sure you set the package location to SQL server

  • December 21, 2009 at 9:17 am

    #1094844

    Do i have go to ssms and click properties and change it to ssis package

    or else i have to click the package in bids save it in soem folder and change it

  • December 21, 2009 at 9:21 am

    #1094851

    you can do this through BIDs.

    It may be possible through SSMS though I have not tried it.

  • December 21, 2009 at 9:34 am

    #1094872

    Thanks a lot

    But i put the sourse as ssis package store and gave the connection for ssis

    and pput the path as msdb\ package

  • December 21, 2009 at 9:34 am

    #1094873

    Is this correct what i did ?

  • December 21, 2009 at 9:39 am

    #1094881

    that seems okay,

    I don't pu MSDB\ in the package path but it could work

    can you see the package when you connect to the reporting server in SSMS?

  • December 21, 2009 at 9:47 am

    #1094890

    When u don't give path doesit automatically saves to msdb

  • December 21, 2009 at 9:55 am

    #1094899

    I usually write

    \PackageName

    And it saves in MSDB fine, you can easily test this by connecting to the integration server in SSMS and expanding MSDB and see if your package is there

  • December 21, 2009 at 10:12 am

    #1094909

    Thats okay , it worked even this way through ssms .

    Thanks for your help !

Viewing 10 posts - 1 through 9 (of 9 total)

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