source control for SQL Agent Jobs

1 vote

0 answers

179 views

Our SQL Agent jobs execute different DTSX packages at various steps. e.g:

\\DEVLserver\DTSX\package1.dtsx

I want to keep the agent job script in TFS but when I promote it is there any way to change or publish it as:

\\TESTserver\DTSX\package1.dtsx
\\PRODserver\DTSX\package1.dtsx

by using variables?

Asked by user65883 (11 rep)

May 6, 2015, 10:05 PM
Last activity: Apr 18, 2018, 08:13 PM