I am reading a connection string for SQL Authenicated user from the SSIS Package Configuration file which looks like
Data Source="ServerName";Initial Catalog="DB";User Id="UID";pwd="PWD";Integrated Security= false;Persist Security Info=True;
I am accessing the above connection string in the script task. But the conection string comes without the password and it says login failed for the user. I am unable to get the password.
Any help is much appreciated. Thanks in advance.
View Complete Post