How to set batch file argument in "Execute Process Task" (SSIS Packages)

Chintan Desai

Hi Guys, I have one batch file. I set argument in it and when I double click the bat file,it work perfectly :). Argument only suggest to execute other SSIS packages on a given path. Argument is:

FOR %%V IN (*.dtsx) DO dtexec /f "%%V" /Config "cfg%%~nV.dtsConfig" >> log_PkgExecution.txt
pause

Now, I want to set the same argument in SSIS Package called "Execute Process Task" in Execute Process Task editor -> Argument property. I did it, but getting problem during execution. On executing the package, DOS prompt is coming blank... I think, it is not getting the argument... Please help, if I am doing something wrong. Thanks in advance. Chintan

leppie

Chintan.Desai wrote:

On executing the package, DOS prompt is coming blank...

It will be. You are redirecting output to the log_PkgExecution.txt file. Have a look in there. Your question is also not C# related.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Chintan Desai

Thx for the reply :) Log file is showing the following:

Started: 12:19:02 PM
DTExec: Stopping the package execution.
Started: 12:19:02 PM
Finished: 12:19:10 PM
Elapsed: 7.938 seconds

I couldn't see the rows affected in my DB by packages which are executed by this bat file...In short, this batch file is not executing the argument.

Regards Chintan

modified on Tuesday, July 15, 2008 5:18 AM