Hi,

I've been trying to store a connection string in any kind of configuration. It seems SSIS never stores the password there.

Do I really have to always enter the password manually into the configuration value? Isn't there an option to have it persisted somehow? Why does the option "encrypt sensitive data" exist if there isn't any sensitive data to encrypt?

Your help is appreciated.

TIA,
Axel Dahmen

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Hello Axel:
SSIS will not automatically save the Password from a Connection String
property in a Configuration. The thing to do is first create the
Configuration entry (xml, SQL Server, etc) then go and manually edit it to
include the "Password=abc123;" clause. But once set up, you should never have
to touch it again.

Check out this blog: http://toddchitt.wordpress.com/2008/06/30/ssis_pw/ for
tips on how to set up a Configuration Database
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Axel Dahmen" wrote:

Guys,

It would also be key to add that although that's a bit more secure
there is a slightly different way mentioned in the link.
The lazy-man's method of doing this is to use a configuration file and
then simply manually edit this and enter the password in the
connection string and password attribute boxes. If you then make the
config read only; it should refer to this and keep your password
saved. The only problem is anyone can see the config and can get your
username and password.

If you've read that and don't know how to make a config file or what
exactly it does. Essentially when the package runs it can refer to the
file and not the default settings you've got in the package. To make
one; in the control flow tab/screen don't have anything selected;
select SSIS from the menu at the top and click 'Package
Configurations'.
Enable this feature and then click 'Add'; the rest should be step by
step and you'll be able to follow.

As a note; if you change any part of the package settings (IPs within
connection managers etc) then you will no doubt need to re-generate
the config file. I haven't tried this with non-read only tho as my
passwords kept disappearing from there too when the option wasn't
turned on the file.

Hope that helps.
JB