Michael Coles: Sergeant SQL : encryption, etl, SSIShttp://sqlblog.com/blogs/michael_coles/archive/tags/encryption/etl/SSIS/default.aspxTags: encryption, etl, SSISenCommunityServer 2.1 SP2 (Build: 61129.1)SSIS: Mo' Secure Configurations http://sqlblog.com/blogs/michael_coles/archive/2010/01/18/ssis-mo-secure-configurations.aspxMon, 18 Jan 2010 22:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:21159Mike C6http://sqlblog.com/blogs/michael_coles/comments/21159.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=21159http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=21159I ran into an issue the other day and I needed a solution for automically configuring my SSIS packages from securely stored DBMS connection strings. Problem is that most DBMSs don’t support Integrated Authentication—they require a username and password....(<a href="http://sqlblog.com/blogs/michael_coles/archive/2010/01/18/ssis-mo-secure-configurations.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=21159" width="1" height="1">SQL Server 2008cryptographyencryptionSQL ServerSQL 2008SSISetlconfigurations