Send multiple parameters SSIS execute process task
Hi, We are using Execute Process Task in SSIS package to execute a batch file to house keep the generated flat files which are older than a week from the archive folder. The same batch file is used to delete the some temp files generated in the process. As the Archive folder and temp folder paths are configurable, we are trying to pass the folder paths as parameters to batch file. I used Expressions tab of Execute process Task Editor to map the variable to Arguments property. This is working fine. but I need to pass one more variable as an Argument. Can some one help me how to achieve this. Thanks in advance. Regards, Sreekanth ABS
September 20th, 2010 2:16pm

To pass multiple arguments to a custom application in one Execute Process task, use spaces to delimit the arguments. An argument cannot include a space; otherwise, the task will not run. You can use an expression to pass a variable value as the argument. In the following example, the expression passes two variable values as arguments, and uses a space to delimit the arguments: @variable1 + " " + @variable2 reference: http://msdn.microsoft.com/en-us/library/ms141166.aspx http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
September 20th, 2010 2:27pm

Hi Reza Raad, I have already gone thorugh this post. But if I use spaces, the package variables are getting passed by their name. The value that the variable holds is not getting passed to the batch file. That's why I used Expressions tab, and created variable as an expression for Argument property. Thanks, Sreekanth ABS
September 20th, 2010 2:34pm

I have already gone thorugh this post. But if I use spaces, the package variables are getting passed by their name. The value that the variable holds is not getting passed to the batch file. what is your expression exactly?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
September 20th, 2010 5:28pm

This is not acceptable. Two of my arguments are Windows Paths (e.g. "C:\Program Files\MyApp") and these have to be able to contain spaces. There must be a way to pass two Windows Paths as parameters to Windows Batch File (using Execute Process Task).Andy Abel
January 24th, 2011 7:10pm

Andy, I enclose the paths in double quotes and the cmd file treats the whole string as one parameter.Russel Loski, MCT
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2011 7:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics