Re: modify user account for dts connections

#1

http://www.sqldts.com/default.aspx?209

dim cn

For each cn in DTSGlobalvariables.Parent.Connections
if cn.ProviderID = "SQLOLEDB" then

cn.UserID = "John"
cn.Password = "Gue55"
End if
Next

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"JJ Wang" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

thanks, Allan,

what I'm looking for here is really the code (any way
other than VB code?) that can modify the user account for
dts connections. sorry for wasn't being clear enough.

'Is there an automated way (by code) that I can change this
employee's account into another account for all
connections in any dts packages?

do I have to correct this manually?'

-----Original Message-----
If you are using Windows Authentication then the account
used will be the
executor.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"JJ Wang" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:0e5001c4a817$db79c000$a501280a (AT) phx (DOT) gbl...
hi,

another question about sql server 2000 dts.

before we drop an employee's account, we would want to
make sure that his accounts won't be used in any dts
package connections on all of our sql servers.

is there an automated way (by code) that I can change
this
employee's account into another account for all
connections in any dts packages?

do I have to correct this manually?

many thanks!

JJ

.

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

Re: modify user account for dts connections

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

Re: modify user account for dts connections - 10-13-2004 , 01:01 PM