Hi All, I feel dumb asking this question as I have never invoked command prompt using SSIS. I am using a ForEachLoop Container to loop through all the files in a folder. And inside the container I want to use Execute Process Task, and it has to invoke the command prompt to run a executable file and take the files through the variable from the container. But here my problem is I dont know what to give for Require File Name Executable Arguments Working Directory StandardOutputVariable StandardInputVariable Can anyone please help me with this. Thanks Vineeshvineesh1701

There are tons of examples, and one is http://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.html Did that help?Arthur My Blog

Hi Arthur, That site is blocked by my company, I tried looking at some posts online but couldnt find anything helpful. Thanks/ Vineeshvineesh1701

Hi Arthur, I figured out to give the details for all except for Arguments, I have given the path for CommandPrompt in Executable, and the executable file name to be used in the Working Directory and it is a tool that already has connection to the database and it will read the data from the input variable files, File location throught the input variable and the packages executed successfully, but I dont see any records inserted into the table. I think it has to do something to do with the arguments, can you help me with this. Thanks Vineeshvineesh1701

Can you access it from my SkyDrive http://cid-725e4de752da5b86.office.live.com/embedicon.aspx/.Public/SQL%20Server%20Solutions%20Zip%20and%20unzip%20files%20in%20a%20folder.mht? Saved in MHT format, so you must be able to use tha page off-line. Arthur My Blog

Hi Arthur, I am able to see the post from the above link, I will try the same and will get back to you with my results. Thanks Vineeshvineesh1701

HI Arthur, Its working fine now, thanks a lot for the help. Thanks Vineeshvineesh1701