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

• Phil Parkin

  SSC Guru

  Points: 246961

  More actions

  January 29, 2018 at 8:20 am

  #1977698

  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

  January 29, 2018 at 8:36 am

  #1977702

  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.