Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by James Greaves SSIS object search using T-SQL RE: SSIS object search using T-SQL

  • June 11, 2010 at 5:00 pm

    #1179483

    Maria Vogel (6/10/2010)

    A number of our packages have XML that is encrypted. Is there a quick way to add decryption to these queries?

    I've been playing around a bit, but haven't found anything yet.

    Thanks!

    I would turn on SQL Profiler and trace the MSDB database when a encrypted package is opening to see how the SQL engine decrypts the SSIS package using a function or something else.