<div>
you could use the &quot;Execute Process Task&quot; .<br />
This will allow you to run an unzip program.<br />
It must be an unzip program that takes command line parameters. Most do.<br />
<br />
You have to remember that the SSIS program must be able to see all the required folders, including where you have stored the unzip program.
</div>


Untitled.png

<div>
<div class="content wysiwyg-content">
<br />
I am an ssis developer and I need to create an ssis package where I have the CSV files which are compressed in .gz files located at located at <a href="http://LabSql01/oxford/mst/import/" rel="ugc">http://LabSql01/oxford/mst/import/</a>&nbsp;. &nbsp;The files are named &nbsp;with the convention of &lt;table name&gt;.csv.gz &nbsp;How can i use the script task to get the files unzipped into the local folder and then get the files from the unzipped folder to read through the file. <br />
There is only one file that exists in the unzipped folder. <br />
<br />
Please guide me through how can i go about it ?
</div>
</div>



I am an ssis developer and I need to create an ssis package where I have the CSV files which are compressed in .gz files located at located at http://LabSql01/oxford/mst/import/ .  The files are named  with the convention of <table name>.csv.gz  How can i use the script task to get the files unzipped into the local folder and then get the files from the unzipped folder to read through the file. 
There is only one file that exists in the unzipped folder. 

Please guide me through how can i go about it ?

you could use the &amp;quot;Execute Process Task&amp;quot; .
This will allow you to run an unzip program.
It must be an unzip program that takes command line parameters. Most do.

You have to remember that the SSIS program must be able to see all the required folders, including where you have stored the unzip program.

How to unzip the compressed files into the local folder and then read it from there usign sql server ssis


I am an ssis developer and I need to create an ssis package where I have the CSV files which are compressed in .gz files located at located at http://LabSql01/oxford/mst/import/ .  The files are named  with the convention of &amp;lt;table name&amp;gt;.csv.gz  How can i use the script task to get the files unzipped into the local folder and then get the files from the unzipped folder to read through the file. 
There is only one file that exists in the unzipped folder. 

Please guide me through how can i go about it ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.