> 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