SSIS loop through Zip files

Question

Post reply

SSIS loop through Zip files

Naughtycell

Old Hand

Points: 354
More actions
January 5, 2011 at 4:16 am

#388556

I have an ssis package that loops through .zip files. there will, at any given time, be over 80 files. I have a for each loop that extracts the files and load them into tables, one at a time. When the loop gets to the 15th iteration, the process terminates. Perhaps know what settings either default or extensions are required for this?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

There is no internal limit as the the number of loops that can happen in a for loop.

You should be able to confirm this by disabling the inner tasks.

There must be an error occurring somewhere.

Clear Sky SQL
My Blog[/url]

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 2

I agree with above also if it is always the 15th file you can edit your loop to pick up that specific file name. I would guess that the file itself may not be correctly zip. What is the specific error message?

Naughtycell Old Hand Points: 354 More actions · Answer 3

It complains about memory... I loop through File01.zip -File82.zip, after file15.zip the task falls over, I the rerun it, the first file is file16.zip ... file31.zip... I rerun the task manually until all the files have been loaded... I think if it was a specific file, it would leave it unprocessed. P.S all files are archived after processing!:-)

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 4

What is the exact error message ?

How are you unzipping the files ?

Is it the process of unzipping the file ?

Is it in the processing of the data ?

Clear Sky SQL
My Blog[/url]

aprilandy83 Newbie Points: 9 More actions · Answer 5

I agree that should be able to confirm this by disabling the inner tasks.

Barnett Crossbows, Barnett Commando Crossbow[/URL]