I am using SSIS 2005. I have multiple source files which are zipped. I have to unzip those source files for which I am using a SSIS Execute Process Task inside a ForEach Loop container.
I am setting the Executable and Arguments properties like this;
1. Executable - M:\Sourcefiles\gzip.exe (also setting this through an expression using a variable)
2. Arguments - -d M:\CDR_Files\MockData\SourceFile\MyFile.NOR.gz (also setting this
through an expression using a variable)
The problem is, it works only for one file and then package stops. It does not iterate through all source files to unzip them all :-(
I tried to disable this Execute Process Task and keep enabled the other tasks inside the ForEach loop container to check whether my ForEach loop is configured correctly. It works properly by scanning through multiple files. But it is not working only in case when I am doing the unzipping.
Any inputs will be very helpful.