November 24, 2009 at 7:21 am
Good Morning fellas, i have deployed my packages to sql server but i cannot view them in sql server management studio, can anybody tell me how to view packages which have been deployed to sql server in sql server management studio. Thank you
November 24, 2009 at 7:31 am
You need to connect to Integration Services on the server.
November 24, 2009 at 7:36 am
ok thanks ll try that
November 24, 2009 at 7:42 am
In addition to what Lynn suggested, you can run the following T-SQL Command
select * from msdb.dbo.sysdtspackages90
Edited: You may want only the name of the deployed packages, so use this
select Name from msdb.dbo.sysdtspackages90
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply