Changing Security to Windows Authentications from sql login

From: JP (anonymous_at_discussions.microsoft.com)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 14:56:04 -0700

Hi

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...

I have posted the same in DTS group also.

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.
Thanks
JP

Relevant Pages

  • Lost permission after restore of MSDB
    ... We restored several db's, including msdb and master, and now some users no longer have permission to run some DTS packages and backup jobs. ... We use Windows authentication and the login is a member of administrator group on the server. ...
    (microsoft.public.sqlserver.dts)
  • Changing Security to Windows Authentications from sql login
    ... 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. ... When you create new connection in DTS for SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: Trouble with sa password
    ... In your DTS packages how are your SQL Server ... > I have Windows Authentication in the Connection ...
    (microsoft.public.sqlserver.security)
  • Re: DTS connection speed
    ... Are all the DTS packages using the same Provider? ... What about copying a file or using a different medium to transfer the ... The timing doesnt' seem to change at all whether its sending 2 or 200 rows, so it seems to be the actual connection rather than the row insert taking the time. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2005: Integration Package Question
    ... selecting the Odbc Data Provider. ... You can then use the Data Reader source against this connection. ... I have been trying to create a data flow task to access the ... > At this point, I don't want to just import the previous dts packages, as ...
    (microsoft.public.sqlserver.dts)
Quantcast