Execute Process Task

• anand_vanam

  SSCrazy

  Points: 2376

  More actions

  August 2, 2011 at 11:14 am

  #242372

  I would like to execute this Statement in Command Prompt.

  "copy C:\Temp\Header.txt+C:\Temp\Data.txt" through Execute Process Task in SSIS.

  I added an Execute Process task to control flow, and

  in the Task Editor

  RequireFullFileName :: False

  Executable :: Copy

  Aruguments :: C:\Temp\Header.txt+C:\Temp\Data.txt

  Working Directory :: Empty

  When I execute this Task...I got this Error "[Execute Process Task] Error: An error occurred with the following error message: "The system cannot find the file specified".

  I think for "COPY" in the Executable option is the issue.

  Please help me on this.

  Thanks

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  August 2, 2011 at 12:25 pm

  #1362477

  You have to put "C:\Windows\System32\cmd.exe" in executable

  Alex S

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  August 3, 2011 at 1:51 pm

  #1363310

  If you're trying to copy a file to a destination, why not use the File System Task? it has a copy function already built in, and avoids you needing to mess around with executing a process.