I;m not entirely comfortable to suggest to use PKZIP within a SQL server process, rather you could run as a windows scheduler job to unzip the contents and then perform remaining SSIS actions using SQL processes. By default PKZIP goest to the TEMP directory on the specified server and ensure the relevant...