开发者

Using an SSIS config file with password in a different location/file

I have a single Sybase user account that accesses many db/tables. I created a config file f开发者_如何学编程or each server/db connection I use in my ssis packages. What i would like to do is store the password for those connections in one place and have the config file access/go get the password at run time. I'm required to change my password once a year I would like to go to one place to change it instead of all the different config files. Is this possible?


Create one config file that holds the connection strings for all your connections - then set up your packages to look at this one file. Configuration files can be shared, so you only need to store it in the one place.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜