Pete Wirfs

Another password challenge (&UC_JOBMD)

Discussion created by Pete Wirfs on May 24, 2016
Latest reply on May 26, 2016 by Michael_Lowry
I have a new RA database agent solution that is logging onto a SQLServer database and running SSIS packages synchronously and performing thorough error checking.  I've also learned to pass connection object credentials into the SSIS package from UC4.  (We prefer to manage these credentials in UC4.)

The problem is how to get the credentials from my LOGIN object into the desired SQL statement without exposing the password.  The &UC_JOBMD trick does not work in the context of an RA database job, so I don't think it is possible?

If we can't get UC4 to do this, then we may have to manage the credentials in the SQLServer environment and code our SSIS solutions to pull them from there.

Outcomes