asked
SQL Job parameter error
I have a SQL job that runs the exact same package three times with different configuration values connecting to different servers. On the third time the package runs I get the error Environment reference Id: NULL. Description: The parameter 'Client' does not exist or you do not have sufficient permissions. Source: .Net SqlClient Data Provider Started: 3:16:03 PM Finished: 3:16:03 PM Elapsed: 0.203 seconds. The package execution failed. The step failed. This error happens in less than one second and I don't have a parameter Client in my SSIS package, job configuration parameter or in the configuration of the Integration Services Catalog. Has anyone seen this error? What I am primarily wanting to hear is suggestions on where else to look for this parameter?
This sure sounds like a security error. I'd guess that something is getting changed during one of the runs that is referenced by this run, or possibly by another process. But the parameter is modified or you don't have the permission. The error is clear. Now you have to find the cause.
15 People are following this question.
