Execute Process Task and Arguments

[dcusick]

What's up all? I have a question for anyone out there that might be able to help me out... I have an executable that I am calling from a DTS Package using Execute Process Task. The executable requires a comma seperated list of arguments based on info in the Database. This data changes everytime the DTS Package is called. I'm going to be calling it from a Stored Procedure. How do I make the Command-Line Arguments a variable that I can change every time? Any help would be greatly appreciated!!! Thanks!

Doug

 

[nigelrivett]

Can use an ectivex script that gets the data and changes the call in the execute process task.

Another way is to use a dynamic properties task which changes it.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.