SQL Job parameter error

• lrdvadr

  SSC Journeyman

  Points: 79

  More actions

  February 12, 2015 at 2:46 pm

  #315270

  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?

• Jim Mackenzie

  Hall of Fame

  Points: 3728

  More actions

  February 18, 2015 at 3:42 pm

  #1778499

  Hi,

  What happens when you run the package manually using the third set of parameters?

  SQL SERVER Central Forum Etiquette[/url]