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 <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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.