Solved

how to zip the files in ssis by using WINZIP32.EXE

Posted on 2012-04-02
1
749 Views
Last Modified: 2012-07-04
in my folder i may have muliple .text files and one .aud text file
how can i zip the all the files by using the process task
0
Comment
Question by:parpaa
1 Comment
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 37800335
That's easy, check All the possible unzip options
http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.html

even there's a community free task to unzip
http://taskunzip.codeplex.com/


another article
http://www.ssisguru.com/2009/10/unzip-and-zip-files-using-ssis.html

Hope that helps, and let me know if you need more help.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Powershell v3 - SQLCMD 3 27
sql server query 12 26
MS SQL query to show nearest date 6 42
too many installs coming along with SQL 2016? 1 17
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question