question

Murff avatar image
Murff 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?
sqlssisparameters
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.