Encryption & Decryption SSIS .config file
Hi Guys., How to perform the SSIS .config file encryption & Decryptions ? Thanks for advance Ranganathan.Palanisamy
April 11th, 2011 10:44am

SSIS can encrypt the package itself, but if you have decided to use XML files for storing sensitive data then you need to implement your own encryption/decryption mechanism or use third-party tools like http://pragmaticworks.com/help/bixpress/scr/ssis-secure-configuration-wizard.htmArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2011 11:27am

Thanks for reply., Any possibilites to use custom encryption decryptions in SSIS package .If Possible how to use it ? Thanks for advanceRanganathan.Palanisamy
April 11th, 2011 11:43am

To achieve the custom encryption goal (hey, why don't you just use a database vs. the XML file?) you need to create a Script Task to run first in which the decryption will occur, to encrypt the config file you can create a console app and then this becomes messy at least from the support point of the perspective, also, to make the encryption/decryption real you would need to use some "already made" DLLs that you would need to distribute with your package, is that really what you are going to do? Think again about storing the sensitive data in a database! Examples of using cryptography in .Net (your Script Task would include code like that): http://www.codeproject.com/KB/security/dotnetcryptog.aspx or http://support.microsoft.com/kb/307010 Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2011 12:03pm

you can write a Wrapper .net application. which reads the encrypted file, and decrypt it, and then fetch config values, and set it on package, and then execute ssis package from .net code.http://www.rad.pasfu.com
April 11th, 2011 2:17pm

Use an XML configuration file. Use NTFS file system encryption on the configuration file. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2011 2:37pm

If you are willing to look at 3rd party tool then try BIxPress- Secure Configuration Manager. It automatically encrypts and descrypts password from Config File or SQL Config Table. It supports 2 encryption mode 1) Basic Encryption (No server side component needed) 2) Advanced Encryption (Custom Serverside component Installation Required) Read more here http://pragmaticworks.com/help/bixpress/scr/ssis-secure-configuration-wizard.htm SSIS Video Tutorial - Secure Configuration Wizard SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring
June 3rd, 2011 11:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics