SSIS - Saved to database

  • Hi,

    I have a made a SSIS through the import data wizard. I asked the wizard to save the SSIS pakage into the database but now I can not see it.

    Where are the SSIS packages saved for when you use the wizard import data wizard to create them?

    Are they stored as stored procedures?

    I don't have integrated services installed on my machine.

    Thank you

  • Have a look at sysssispackages in msdb?

  • USE msdb

    GO

    SELECT * FROM dbo.sysssispackages

    That's where they are. To run them, or edit them, you'll need BIDS/SSDT

  • Open SSMS

    click on the connect drop down and choose integration services

    go to "stored packages" => MSDB

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

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