April 20, 2009 at 8:15 am
I have various SSIS packages that pull data from SQL Server 2005, and formulate flat files for reporting to various customers.
Due to sensitivity on some of the held data in SQL Server, they have implemented column encryption using symmetric key certificate.
Is there any way for SSIS to utilize the certificate they set up so I can pull decrypted data?
Thank you in advance for your time - please let me know if you need more information. Currently I am the only one in our group that is learning/using SSIS, and I have not had much luck in finding any answer to this question - other than SSIS doesn't have anything direct to handle data from an encrypted source.
April 20, 2009 at 11:13 am
Not sure if you could use certificates directly in SSIS, but u can always use the Encryption and Decryption functions provided in SQL Server to use as execute SQL Tasks or in variables as SQL Statements to your Data flow task.
April 21, 2009 at 6:45 am
Thank you for the input; I will look into your suggestions.
Have a great day!
Lisa
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply