SQL 2005 Saved SSIS Packages 1

[Skittle]

I think I must be missing something obvious but when you save a SSIS package on SQL server, where is it stored so that you can see a list of stored SSIS packages and then rerun one?

Dazed and confused

 

[Catadmin]

You need to connect to Integration Services before you can see it. Go up to CONNECT in SSMS, choose Integration Services, then enter your server. After a moment, you'll see it added to your Object Explorer. Then you'll see two folders (Running Packages and Stored Packages). It should be somewhere under Stored Packages.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Skittle]

Many thanks.

Dazed and confused

 

[Catadmin]

You're welcome. @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"