posted 2/22/2011 by kylewalker - Views: [6599]
When you're working in SSIS, there are definitely some quirks that can drive you crazy. Luckily, most of them have a pretty simple resolution. One example of this is Connection Manager passwords not being saved in your package. Let's say you set up a connection to an Oracle database that looks something like this:
Now, when you test the connection, it tests successfully. But when you apply a configuration to this connection (on the Connection String), the password is not saved. So if you try to run the package with a config applied, you will get an error message similar to this one:
If you take a look at the configured value of the connection string, here's what it would look like (if you're using SQL Server configurations):
And you'll notice there's no mention of a password.
While you were setting up your connection string configuration, you may have seen an option for the password as well. And you might think that selecting the "Password" checkbox will do the trick. However, this will not solve your problem that the error is referencing. You will have to manually update your configured value to include the password within the connection string. Like this:
Like I said, pretty easy resolution when you know where to make the changes. I hope this helps.
Thanks for sharing, Cheers!