Solved

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

Posted on 2012-04-02
1
714 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:
huslayer earned 500 total points
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Microsoft SQL query 7 38
CREATE DATABASE ENCRYPTION KEY 1 41
The duplicate key value is (<NULL>) 14 44
C# SQL BULK INSERT CLASS 5 34
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now