Re: what encryption is used in DTS

From: TipTop (anonymous_at_discussions.microsoft.com)
Date: 11/26/03 

Date: Wed, 26 Nov 2003 05:01:05 -0800

Thanks for your help. The password is for ODBC connections to a non SQL Server database which doesn't support NT or Active Directory authentication.

I think the answer lies in the default Cryptographic Service Provider installed on the machine, still would be nice to know what default symmetric algoritm is used. I've added the link to where I found out CryptoAPI is used in DTS:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1061.asp