sql server dts: Changing Authentication to Windows Logon -- sql server dts

Changing Authentication to Windows Logon

JP
2/6/2004 9:15:21 AM

sql server dts: Hi

We are in process of changing SQL Server authentications
to Windows Authentications.

We have only 1 issue... lots of DTS packages created by
users. Is there any easy way I can change all
authentication to Windows Authentication without opening
DTs packages????

I mean, changing sysdtspackages table or any other tables..

Appreciate your help greately.

Thanks

Re: Changing Authentication to Windows Logon

Allan Mitchell
2/6/2004 6:33:40 PM

Open the packages using the Object model and loop through the connections
and change them there.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]