SSIS newbie here...

I have developed a package for importing data from text files into a
SQL server database. In this package I'm using an OLEDB Connection
Manager. I would like to be able to specify the connection string for
this connection manager when I deploy the package.

My question is what's the best/typical/preferred approach: creating an
XML package configuration, or storing the package configuration in a
SQL server? Apparently, if I create an XML package configuration, I
have to manually add the password to the connection string and then
it's stored as plain text in a file (never a good thing).

Thoughts?

Thanks!
David

Hello david,

Configurations like you have discovered are the way forward for this. You
should store the info in a place that is safe. Can you secore the location
of the Configuration file and the file itself?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Yes, I suppose that I can. It actually seems as though the .dtsConfig
file is created in such a way that the average-user can't read it
anyways, only those in the Administrators group (of which my account
belongs).

I wasn't sure if this was the widely accepted method as it still seems
foreign to me to save a password, unencrypted, in a file.