How do I tie the agent job to the ETL packages for audit and run monitoring

  • Is there a way to pass in a job info to an SSIS package? Like the job instance ID or the Job Guid?

  • One way I could do this is to put the job Guid into a package variable using the Set Values on the job setup. See screenshot.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply