Is it possible to script adding a sql agent job for an SSIS package that uses one or more configuration files? I've spent the better part of the day searching forums and blogs for any examples, but all I can find is just default TSQL or stored proc
jobs. I have most of the script written to pull the appropriate information in, I just do not see how I can specify the configuration files for the job step. And yes, I've even tried going through Visual Studio accessing that api to see if i can
dig out the appropriate object/property to no avail...
Any help would be incredibly appreciated as this would make a huge step forward for our deployment process :)
---- UPDATE ----
I know this sounds odd, but I'm mostly asking because I can't even access a sql 2008 server right now to see what gets put into the step normally for the SSIS Package..I'm assuming all it's really doing in that step is a dtsexec with the appropriate switches,
if this is the case, then I can probably just build the command out to pass in multiple configurations...?
View Complete Post