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
JP

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


"JP" <dsjpatel (AT) yahoo (DOT) com> wrote