Hi,

    I have 13 zip files in a location. I want to unzip all files and load them into respective sql server tables. I am wondering whether it is possible to unzip all files at once instead of picking one-by-one? I can use For-Each loop container but again it picks up each file and process it and picks another file and so on.. is it possible to pick all files at once and unzip them? Any solution would be helpful 

Regards,

V

Then you have 13 Control flow tasks to unzip file . and execute in parallel

Well you can use multiple tasks in parallel .. to unzip file simultaneously, but again having 13 parallel unzip task is not recommended so you can run couple of parallel tasks in parallel.. check below article for some inside view 

http://sqlmag.com/sql-server-integration-services/designing-ssis-packages-high-performance 

Thanks,

Saurabh