Post reply

Execute Process Task

  • 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

  • August 2, 2011 at 12:25 pm

    #1362477

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

    Alex S

  • 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.

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

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