Set the executable as %windows root folder%\System32\cmd.exe for e.g. C:\Windows\System32\cmd.exe. Have never tried it but reckon that for multiple lines you would have to separate each line by a carriage return.http://btsbee.wordpress.com/

Just tried this. 1) Set the executable as C:\Windows\System32\cmd.exe 2) Set the arguments in the expression as "C:\\Windows\\System32\\cmd.exe /c TYPE" + @[User::FullSourcePathFileName] + " >> " + @[User::FullDestinationPathFileName Also you cannot have multiple lines of command, instead have multiple Execute process task.http://btsbee.wordpress.com/

Hi, I have files in C:\Extract folder I want to move the files into C:\ExtractMegre i want to merge all the files in the extract folder with the files already exist in the C:\ExtractMegre I have some idea of using For each loop and Execute Process Task Code Snippet TYPE "C:\Extract\Sales.txt" >> "C:\ExtractMegre\SalesDestiny.txt" Could you let me know the ways to implement this tasks where the file path is comming from vairableShanmugaRaj

There is a similar thread here: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/d70bd8b9-d3b1-4ba3-b37a-6ddefddd45ecPlease vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

I have already seen this.. this is not having any steps for mentioning the for each file and the passing path in parameterShanmugaRaj

1) Use a foreach container to loop through all files in C:\Extract (Use file enumerator) 2) Inside the foreach container, put an execute process task. Select expressions and set the argument of the execute process task as: "TYPE " + @[User::FullSourcePathFileName] + " >> " + @[User::FullDestinationPathFileName] where FullSourcePathFileName comes from the ForEach container and FullDestinationPathFileName will be set to "C:\ExtractMegre\SalesDestiny.txt" Note: The merged file cannot be in the same folder which the foreach container is enumerating on. So either keep the files in C:\Extract or create your merged file on a different folder path.http://btsbee.wordpress.com/

In the Execute Process Editor after setting the expression, i am getting warnig as "An executable file not set". what to set ? also, can i mention multiple lines of dos command in the argument of this task ?ShanmugaRaj