SSIS Catalog using Transparent Data Encryption?

  • npranj

    SSCrazy

    Points: 2323

    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?

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • npranj

    SSCrazy

    Points: 2323

    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 ?

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • npranj

    SSCrazy

    Points: 2323

    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.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply