dbTalk Databases Forums  

In what table will I find my packages?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss In what table will I find my packages? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
IanO
 
Posts: n/a

Default In what table will I find my packages? - 12-05-2006 , 10:01 AM






When I connect to Intergration Services, expand msdb folders, I can see
my packages.
However when use the database as in:

use msdb
go
Select top 11 *
from dbo.sysdtspackagefolders90


Select top 11 *
from dbo.sysdtspackages

I can see the folders from the first query but cannot see any packages
in the second query.
Just wondering...where are they?

IanO


Reply With Quote
  #2  
Old   
IanO
 
Posts: n/a

Default Re: In what table will I find my packages? - 12-05-2006 , 10:24 AM






Oops there are in

Select top 11 *
from dbo.sysdtspackages90

IanO


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.