Pass JOBID from SQL Job Agent to project parameter fails "Failed to configure an overridden property"

61 Views Asked by At

I've been able to map a token from SQL Job Agent to a user variable in SSIS with this approach:

SQL Agent mapping

If the picture can't be seen: I've edited the job step in SQL Job Agent under Configuration -> Advanced to have Property Path \Package.Variables[User::SQLAgent_JobID].Value and Property Value $(ESCAPE_NONE(JOBID)).

This works, but I'm intending to do this for a project variable with the same name but I receive the error "Failed to configure an overridden property" doing this.

I've tried different Property Paths like:

Project.params[SQLAgent_JobID].Value
\Project.params[SQLAgent_JobID].Value
\Package.Variables[Project::SQLAgent_JobID].Value
\Package.Variables[$Project::SQLAgent_JobID].Value

but the error persists. Does anyone know the Property Path syntax needed to map a token to a project parameter (if it is possible?)?

0

There are 0 best solutions below