encrypting ssis package configuration file

Question

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.

Answer 1

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

Answer 2

No, you can't encrypt config file.

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 3

You could try to use SQL Server as your configuration type.  In this case, all the configuration item are stored in the table of SQL Server and you could use access control like DENY from SQL Server to protect the sensitive data.

Answer 4

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, then you 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.