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 ?