I want to place my database connection strings into a xml configuration file but it needs to have the sensitive information encrypted. Is there a way to encrypt the package configuration file? (something like the asp.config file). Or is there another way of doing this? Thanks.

As far as I know, you cannot encrypt the package config file.If you want to encrypt the sensitive information then yu can use "Encrypt Sensitive With Passowrd" as Package Protection level.Nitesh Rai- Please mark the post as answered if it answers your question

No, you can't encrypt config file. Let us TRY this | Dont forget to mark the post(s) that answered your question

You could try to use SQL Serveras your configuration type. In thiscase, all the configuration item arestored in the table ofSQLServer and you coulduse access control like DENYfrom SQLServerto protect the sensitive data.

What Renhe Li has suggested is the best option and also the right option. But if in your requirement you have to save it in a file system, thenyou can protect the file doing a folder lock on the parent folder. Out of the box SSIS dont have flexibility in encrypting the config file.Thanks, Bharani M - Please mark the post as answered if it answers your question. - Please vote the post as Helpful if you find the post as helpful.

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