Password is not saving in SSIS config Table?
hi all,
i have created ssis package , having sqlserver configurations. inside package, hv oracle connection manager , configured servername,username , password.
in config table, password coming '****' and not affecting while running server. how can save password in decrypted format in config table.
if run package sqlserver(either sqlserver agent or msdb). getting error of authentication failed.
in oracle connection manager editor, have checked in save password checkbox.
could please let me know how can save password in config table , if can update password in config table should affect in package while try execute it.
thanks & regards, anil
best regards,uri dimant sql server mvp,http://sqlblog.com/blogs/uri_dimant/
SQL Server > SQL Server Integration Services
Comments
Post a Comment