Changing Security to Windows Authentications from sql login -
04-05-2004
, 04:51 PM
H
I have around 300+ DTS packages, with most of the have been created by users with SQL Login information
MY company is now moving to Windows Authentication.
There two places where we can put SQL Login information in DTS Packages
1. When you create new connection in DTS for SQL Server
2. When you save DTS packages..
It is lots of manual work to change all the dts packages to windows authenticatiosn.
Is there any simple and automatic way to change all the connections to use windows authentications....????
Appreciate your help
Thank
JP |