April 20, 2009 at 8:03 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 certificates.
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 21, 2009 at 5:56 am
lisa.stein (4/20/2009)
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 certificates.
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.
You are in a wrong forum, mate. This is Reporting Services.
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
April 21, 2009 at 8:17 am
Hello, thanks for the input. About 30 seconds after I clicked on "post", I'd realized my mistake. I thought I was sucessful in deleting it, but obvously not. 🙂
Have a good one! 🙂
Lisa
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply