Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Catalog using Transparent Data Encryption? Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 5:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 8, 2014 5:51 AM
Points: 48, Visits: 297
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?
Post #1600568
Posted Thursday, August 7, 2014 6:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
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.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1600596
Posted Thursday, August 7, 2014 10:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 8, 2014 5:51 AM
Points: 48, Visits: 297
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 ?
Post #1601018
Posted Friday, August 8, 2014 1:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
TDE is per database. So you would have to enable TDE on the SSISDB database.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1601049
Posted Friday, August 8, 2014 3:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 8, 2014 5:51 AM
Points: 48, Visits: 297
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.
Post #1601096
Posted Friday, August 8, 2014 4:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1601097
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse