Dynamically change a configuration file variable value in a sql agent job

• Griffster

  SSCertifiable

  Points: 7097

  More actions

  October 14, 2011 at 9:11 am

  #246483

  I've developed an ssis package that runs from an xml configuration file. Two of the variables in this configuration file are a start and end date which is fed in to a few stored procedures run by the package. I've added this package to a sql agent job.

  What I want to do though, is to set the sql agent job to run from a schedule, and I want the end date fed in to the package to be the date the sql agent job runs according to the schedule. In other words, i effectively want the end date that's contained in the configuration file to basically change to the sql agent job run date.

  Is there a way of doing this please, and if not, what's the best way around it?

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  October 14, 2011 at 11:54 am

  #1394802

  Yeah you can.

  See this thread:

  http://www.sqlservercentral.com/Forums/Topic1172069-148-1.aspx

• Griffster

  SSCertifiable

  Points: 7097

  More actions

  October 19, 2011 at 7:20 am

  #1396624

  Would I have to set all the variables I refer to in my xml configuration file i.e. my dtexec command will skip the configuration file and so I'll need to set each one in my command line script?