Encrypting Connection string of a connection in an SSIS Package
-
Hi, I have few SSIS Packages which have Connections which deal with sensitive Data, so far how I am doing is, I have a variable which holds the Connection string of the sensitive Data Connection, I am going to set that variable value at runtime from .Net code which executes the Package, the variable value is stored in the Database in AES Encrypted format, to protect my Connection String so far I am deleting the User Id Password values from the variable, before putting SSIS Package onto the FileSystem to be executed by .Net code (this is so that unwanted people can't see the credentials). But when I need to test, debug or edit the Package I need to put the values statically and execute the Package to see the results, because Dataflow needs static connection with proper connection string (there are Dynamic Dataflows are there which can pickup the connection string at run time, but we are not using those here though). So far this is what going on to protect the credentials for the sensitive Database. But if I can encrypt the Connection string even at the static level and edit or execute the Package, it would be great, is there anyway to do it? Or is there any better approach to secure my credentials than this approach, please give me your great suggestions. Obviously I believe few more brains are better than one brain in lot of situations. Thanks in advance my friends. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."