0

I am setting up an SSIS project for testing. This project has a package where I manage some connections to SQL Server data bases, for doing this I use Package Configurations. Here I have a configuration that takes four connection strings from a table. Each is being mapped to connection string property of SSIS OLEDB connection (As shown in next image). enter image description here

When I turn off "Work offline" and test the connection it works, the problem is that when execute the solution it logs some errors that are releated with the incorrect login to the data base. I tried to do some workaround for this by setting everything manually (without Package Configurations) and changing protection level to "EncryptSensitiveWithPassword" and it worked. It seems that the password of the connection string is not being saved when being taken from package configurations.

Rafael
  • 117
  • 1
  • 9
  • Please show an example of connection string stored within the database? – Hadi Jan 01 '20 at 22:15
  • Data Source=********;User ID=******;Password=******;Initial Catalog=********;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False; @Hadi – Rafael Jan 02 '20 at 18:38

0 Answers0