Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issue in using Execute Process Task in a ForEach Loop container for unzipping multiple files. Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 1:07 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:09 AM
Points: 75, Visits: 211
Hi,

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.

Regards.
Post #1430787
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse