February 26, 2014 at 9:51 am
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
February 26, 2014 at 10:23 am
Have a look at sysssispackages in msdb?
February 26, 2014 at 10:58 am
USE msdb
GO
SELECT * FROM dbo.sysssispackages
That's where they are. To run them, or edit them, you'll need BIDS/SSDT
February 26, 2014 at 11:06 am
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