x

File Compression SSIS

What component do I use to compress files using SSIS in 2008 R2?

I cannot install any third party software to do this.

more ▼

asked Jan 14, 2011 at 07:54 AM in Default

avatar image

Raj More
1.8k 82 88 90

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You can use an execute process task to call a compression program.

here is a walk-through using 7-zip: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

EDIT

A couple of possibilities using MS tools instead of 3rd party:

/EDIT

more ▼

answered Jan 14, 2011 at 08:27 AM

avatar image

KenJ
24.9k 3 10 19

I cannot install third party software on the server. 7Zip is not available to me as an option.

Jan 14, 2011 at 08:48 AM Raj More

I missed that when i read the initial question

Jan 14, 2011 at 09:53 AM KenJ

@Raj More Read through the article's discussions. Some of them offer using SharpZipLib, which could be a better option than using a third-party app. SharpZipLib is technically a third-party assembly, but it does not really require an installation, and it exists simply to allow compressing / decompressing files using managed code. So, instead of using process task you can use script task which will only require you to add a reference to SharpZipLib assembly and write few lines of .NET code.

In case you cannot drop the dll on your server's hard drive then you can actually download the source code of the SharpZipLib and use it in your script task. This would be an overkill though. If I were tasked to have the SSIS package with zip capabilities, I would definitely go for script task and SharpZipLib.

Jan 14, 2011 at 09:54 AM Oleg

@KenJ - you didn't miss that when you read the question, it wasn't there! OP added it in revision 2.

Jan 14, 2011 at 11:30 AM Kev Riley ♦♦

Thanks @Kev. I thought I was losing it for a moment!

Jan 14, 2011 at 11:37 AM KenJ
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1208
x775
x20
x4

asked: Jan 14, 2011 at 07:54 AM

Seen: 6321 times

Last Updated: Jan 14, 2011 at 08:47 AM

Copyright 2017 Redgate Software. Privacy Policy