I added an Execute SQL Task to my control flow.
I configured it to use a connection manager.
When I pressed Build Query I got an error saying Login failed for user xxx.
I checked the settings on my connection manager 100 times.
After googling a while I found that it could be because the ProtectionLevel is set to encrypt sensitive settings.
So in order to check if this was the thing causing my error, I had to change my ProtectionLevel to DontSaveSensitive instead. Ok, so I did this on project level.
When I build I get error because Package.dtsx has a different ProtectionLevel than the project. So I need to change for the package as well. But I can't find the setting! It is not on the property page for the package, and I don't know where else to look.
Any suggestion?
Edit: See picture
