Re: DTS Connection Login

#1

In article <A06F81AD-3496-4C1A-AA11-650D5E07BB1E (AT) microsoft (DOT) com>, JaneDoe wrote:

Quote:

I need to find all DTS packages that use 'sa' as the connection login.
Rather than going into each one (there are 1000's), is there a way to get
this information from the system tables?

Thank you,
Michelle Vairo

Short answer is no. DTS packages are stored as binary objects.

You can though use the object model to open each package and iterate through
the connections collection to find out the username

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

#2

Thank you, Allan. Where can I find information on using the object model?
I'm not sure what you mean.

Thanks,
Michelle

"Allan Mitchell" wrote:

Quote:

In article <A06F81AD-3496-4C1A-AA11-650D5E07BB1E (AT) microsoft (DOT) com>, JaneDoe wrote:
I need to find all DTS packages that use 'sa' as the connection login.
Rather than going into each one (there are 1000's), is there a way to get
this information from the system tables?

Thank you,
Michelle Vairo

Short answer is no. DTS packages are stored as binary objects.

You can though use the object model to open each package and iterate through
the connections collection to find out the username

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Connection Login

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

Re: DTS Connection Login - 09-22-2004 , 04:31 PM

Re: DTS Connection Login - 09-23-2004 , 08:47 AM