SSIS Authentication Changing From SQL Authentication to Windows Authentication

Question

Hi,

      I have an ssis package which was successfully running with SQL authentication.Suddenly I have a requirement in which from SQL Authentication  I need to change the authentication for SSIS package to windows authentication.

Can anybody please tell me what all the places we have to check once we change to Windows authentication.I have already changed the config file for windows authentication.

 

Please help me its very urgent.

Answer 1

Hi,

 

Change the Connection manager to Windows authentication. Need to change every connection manager.

If you used data source view. First change data source in BIDS and recompile. It will update all connections.

Answer 2

Hi,

 

Change the Connection manager to Windows authentication. Need to change every connection manager.

If you used data source view. First change data source in BIDS and recompile. It will update all connections.

Hi Thanks For Ur Reply................

             I am using dtsconfig files to provide the values to connection managers.Then do I need to explicitly change the values in connectiion Managers.

Answer 3

Hi Thanks For Ur Reply................

             I am using dtsconfig files to provide the values to connection managers.Then do I need to explicitly change the values in connectiion Managers.

In that case you just need to change the config file and use the appropriate connection string.

---