Post reply

Save SSIS Package

  • November 27, 2006 at 9:56 pm

    #117817

    I have created an SSIS Package. I wish to store this package in the MSDB Database so that I can then schedule it via a Job.

    How do you save the package to the MSDB Database?

    Kindest Regards,

  • November 28, 2006 at 12:23 am

    #674241

    Hi,

    I think you can save a copy of a package to the msdb database.

    To see exactly how, look at the "How to: Save a Copy of a Package" Item in the help file.

    You shoudl just select the location as SQL Server.

     

  • November 29, 2006 at 7:52 am

    #674658

    You can create a job that fires an SSIS package in the file system also...

  • April 20, 2007 at 1:22 pm

    #701801

    1. Launch the SQL Server Management Studio and connect to the Integration Services Server.

    2. Right click on the MSDB folder and import SSIS packages by specifying the filepath.

     

     

     

     

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

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