SSIS -Registry setting specifying configuration file does not exist

Standard

I was having an issue getting an agent job from completing when running a package that relies upon an Indirect XML Configuration File. When executing the agent job I received a couple of warnings, one from the SSIS Package itself and another from the Event Viewer:

Event Viewer:

SSIS_EnvVar.png

SSIS catalogue error:

SSIS_EnvVar2.png

The problem here was that I had my environment variable used to specify the location of my config file set up in my User Variables and not in System Variables. This was also a problem because I’d specified the [NETWORK\SQLAgent] user as the SQL Agent service logon account.

SSIS_EnvVar3.png

Once I switched my variable into System Variables my agent job ran through without error.

Advertisements