Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS - Saved to database Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 9:51 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
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
Post #1545474
Posted Wednesday, February 26, 2014 10:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 451, Visits: 1,663
Have a look at sysssispackages in msdb?
Post #1545489
Posted Wednesday, February 26, 2014 10:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:28 PM
Points: 33,062, Visits: 15,174
USE msdb

GO
SELECT * FROM dbo.sysssispackages

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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1545501
Posted Wednesday, February 26, 2014 11:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, May 5, 2014 6:31 AM
Points: 291, Visits: 519
Open SSMS
click on the connect drop down and choose integration services
go to "stored packages" => MSDB
Post #1545507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse