October 14, 2011 at 9:11 am
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?
October 14, 2011 at 11:54 am
October 19, 2011 at 7:20 am
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?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply