August 7, 2014 at 5:53 am
In cases when the SSIS package has to be deployed in SQL Server, when we use ProtectionLevel ="server storage" while creating SSIS Catalog, does it use TDE? or Database Standard Encryption? if the database is using TDE?
August 7, 2014 at 6:41 am
I don't think it uses TDE, as TDE would encrypt everything in the database, while the SSIS catalog only encrypts sensitive data and parameters using a database master key.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 7, 2014 at 10:32 pm
thanks. SSIS does use standard Database encryption (and not TDE) for encrypting sensitive data ..my question is - if SSIS package is deployed on SQL server which already is TDE encrypted (i.e LDF,MDF files are exncrypted) , then would the SSIS package stored in the SQL also get TDE encrypted automatically ?
August 8, 2014 at 1:03 am
TDE is per database. So you would have to enable TDE on the SSISDB database.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2014 at 3:57 am
Thanks Koen this helps. So as I understand, if we encrypt the SSIS DB using TDE then all the packages deployed in SSDB will also be encrypted using TDE automatically.
August 8, 2014 at 4:01 am
npranj (8/8/2014)
Thanks Koen this helps. So as I understand, if we encrypt the SSIS DB using TDE then all the packages deployed in SSDB will also be encrypted using TDE automatically.
I haven't done this myself, but I would assume so.
I would test first before you deploy anything to production.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply