Skip to Content
0
Aug 08, 2016 at 10:54 PM

Data Services - bulk assignment of global variables

350 Views

Short version:

How can we set a bunch of global variable values without having to open each one and change them individually? It seems like these values must live somewhere within the repository where we can do a simple UPDATE AL_<sometable> set value = 0;

Long version:

One of the nice features of SSIS is being able to right click and run a portion of the ETL job without having to run the entire job. This feature either isn't available or isn't obvious within Data Services. It's very cumbersome to run the entire ETL job each time to troubleshoot an issue with a specific portion of the data load. Our solution is to put global variables in place -- either a zero or a one -- that control various pieces of the data load. Sometimes when we want to work on a small portion of the job, it takes a significant amount of time to open up and change all of the global variables to disable things.

Attachments