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: Monday, October 13, 2014 1:58 PM
Points: 753, Visits: 1,070
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: Wednesday, September 24, 2014 5:37 AM
Points: 498, Visits: 1,845
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 @ 4:56 PM
Points: 31,168, Visits: 15,612
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: 288, 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