Hi All,
I have a SSIS package, which uses Indirect xml configuration. Xml stores the configuration string for sql server. i added password to the configuration string in xml (as i am using sql server authentication) as it would not get stored when its created. i have a script task in the package which uses the connection string to execute a stored procedure.
problem i am facing is, script task throws out a error saying, login failed for the user. the userid and the password i gave are valid. when i debug the script task, the configuration string is not picking up the password as a result its failing. any help here is highly appreciated.