Execute Process task fails when Arguments property is set as an expression

Question

Execute Process task fails when Arguments property is set as an expression

Wolfmeister

SSCommitted

Points: 1547
More actions
January 29, 2018 at 8:00 am

#343075

I've set up an SSIS Execute Process ask to call a batch file that pushes the contents of a folder to an Amazon S3 bucket, as follows:
Executable: \\Sqlcluster7.justgiving.qube\d\PSTools\PsExec.exe
Arguments: \\192.168.20.73 -accepteula -s cmd.exe /c "f:\Batch Files\S3 Push\poc-raven-oltp-ls_fraud_analysis.bat"
Working Directory: \\Sqlcluster7.justgiving.qube\d\PSTools
This works perfectly - as long as these values are hard coded. When I try to assign any of these properties to expressions within the Execute Process task is where I'm having problems.
Really it's only Arguments that I need to parametize -
"\\\\" + @[$Package::S3BatchFileShare] + " -accepteula -s cmd.exe /c " + "\"" + @[$Package::S3BatchFilePath] + "\\" + @[$Package::S3BatchFileName] + "\""
The result of this expression is:
\\192.168.20.73 -accepteula -s cmd.exe /c "f:\Batch Files\S3 Push\poc-raven-oltp-ls_fraud_analysis.bat"
However when I set the property expression to the above and run the task, it says it's been successful but nothing happens - no files are getting pushed.
Any help would be most appreciated.
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246961 More actions · Answer 1

Wolfmeister - Monday, January 29, 2018 8:00 AM
I've set up an SSIS Execute Process ask to call a batch file that pushes the contents of a folder to an Amazon S3 bucket, as follows:
Executable: \\Sqlcluster7.justgiving.qube\d\PSTools\PsExec.exe
Arguments: \\192.168.20.73 -accepteula -s cmd.exe /c "f:\Batch Files\S3 Push\poc-raven-oltp-ls_fraud_analysis.bat"
Working Directory: \\Sqlcluster7.justgiving.qube\d\PSTools
This works perfectly - as long as these values are hard coded. When I try to assign any of these properties to expressions within the Execute Process task is where I'm having problems.
Really it's only Arguments that I need to parametize -
"\\\\" + @[$Package::S3BatchFileShare] + " -accepteula -s cmd.exe /c " + "\"" + @[$Package::S3BatchFilePath] + "\\" + @[$Package::S3BatchFileName] + "\""
The result of this expression is:
\\192.168.20.73 -accepteula -s cmd.exe /c "f:\Batch Files\S3 Push\poc-raven-oltp-ls_fraud_analysis.bat"
However when I set the property expression to the above and run the task, it says it's been successful but nothing happens - no files are getting pushed.
Any help would be most appreciated.
Thanks

For the sake of testing, are you able to try using file paths which do not contain any spaces? In your case, something like this, perhaps:

\\192.168.20.73 -accepteula -s cmd.exe /c "f:\BatchFiles\S3Push\poc-raven-oltp-ls_fraud_analysis.bat"

Spaces are a common cause of issues with the EP task.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Wolfmeister SSCommitted Points: 1547 More actions · Answer 2

Phil Parkin - Monday, January 29, 2018 8:20 AM
Wolfmeister - Monday, January 29, 2018 8:00 AM
I've set up an SSIS Execute Process ask to call a batch file that pushes the contents of a folder to an Amazon S3 bucket, as follows:
Executable: \\Sqlcluster7.justgiving.qube\d\PSTools\PsExec.exe
Arguments: \\192.168.20.73 -accepteula -s cmd.exe /c "f:\Batch Files\S3 Push\poc-raven-oltp-ls_fraud_analysis.bat"
Working Directory: \\Sqlcluster7.justgiving.qube\d\PSTools
This works perfectly - as long as these values are hard coded. When I try to assign any of these properties to expressions within the Execute Process task is where I'm having problems.
Really it's only Arguments that I need to parametize -
"\\\\" + @[$Package::S3BatchFileShare] + " -accepteula -s cmd.exe /c " + "\"" + @[$Package::S3BatchFilePath] + "\\" + @[$Package::S3BatchFileName] + "\""
The result of this expression is:
\\192.168.20.73 -accepteula -s cmd.exe /c "f:\Batch Files\S3 Push\poc-raven-oltp-ls_fraud_analysis.bat"
However when I set the property expression to the above and run the task, it says it's been successful but nothing happens - no files are getting pushed.
Any help would be most appreciated.
Thanks
For the sake of testing, are you able to try using file paths which do not contain any spaces? In your case, something like this, perhaps:
\\192.168.20.73 -accepteula -s cmd.exe /c "f:\BatchFiles\S3Push\poc-raven-oltp-ls_fraud_analysis.bat"
Spaces are a common cause of issues with the EP task.

Thanks Phil for your prompt reply. I created a directory called F:\Temp but unfortunately that hasn't made a difference.