Using SSIS to zip files and email the zipped files

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Carolyn Richardson » Using SSIS to zip files and email the zipped...

77 posts, Page 1 of 8

1 2 3 4 5 »»»

Using SSIS to zip files and email the zipped files

Rate Topic

Display Mode

Topic Options

Author

Message

Carolyn Richardson

Posted Saturday, September 20, 2008 8:50 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:52 AM
Points: 1,397, Visits: 2,738

Comments posted to this topic are about the item Using SSIS to zip files and email the zipped files

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists

Post #573090

Anipaul

Posted Monday, September 22, 2008 1:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:35 AM
Points: 4,789, Visits: 1,336

Nice article ....

Post #573294

shrikant-279400

Posted Monday, September 22, 2008 5:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, August 26, 2012 9:40 PM
Points: 128, Visits: 153

Hi Carolyn,
you have made it really simple. awesome!!! [:)]

Regards
Shrikant
(India)

Post #573389

0x30

Posted Monday, September 22, 2008 6:31 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 5:43 PM
Points: 19, Visits: 80

Or instead of breaking out into a external process, you can use the script task and SharpZipLib (http://www.icsharpcode.net/OpenSource/SharpZipLib/) or DotNetZip (http://www.codeplex.com/DotNetZip) C# Zip frameworks.

This is how we utilize zipping requirements in our control flows.

Post #573429

Idris Ogueboule

Posted Monday, September 22, 2008 8:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 01, 2011 1:03 PM
Points: 9, Visits: 166

Good article Carolyn. Any idea about the maximum size of the files that can be zipped or the zipped file itself?

Post #573569

Carolyn Richardson

Posted Monday, September 22, 2008 9:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:52 AM
Points: 1,397, Visits: 2,738

I think its up to 4GB, using 7 zip, but you should really check on the 7 zip site http://www.7-zip.org/. If the files you want to zip are bigger than this, you could always look at the products Grasshopper mentions.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists

Post #573602

Bk-384756

Posted Monday, September 22, 2008 9:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 26, 2012 4:51 PM
Points: 7, Visits: 73

Thanks for the great article, Carolyn!

Shouldn't it also be possible to use native Windows functions to compress and uncompress groups of files into .zip-compatible archives? NOT "compress" like the command line .exe or operating system file attribute, but similar to how I can view/create compressed .zip-compatible files from Windows Explorer.

Any thoughts?
Bk

Post #573660

Festeron

Posted Monday, September 22, 2008 10:05 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 12, 2013 9:43 AM
Points: 142, Visits: 171

It's nice to see zipped files being used by SSIS, and most of the article was good, but surely there's a bug in this code:

If Len(strDay) = 1 Then
strMonth = "0" + strDay
End If

Post #573668

Liam Gavin-382521

Posted Monday, September 22, 2008 10:08 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 14, 2009 9:37 AM
Points: 15, Visits: 153

Great article, thanks for sharing

Post #573673

Carolyn Richardson

Posted Monday, September 22, 2008 10:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:52 AM
Points: 1,397, Visits: 2,738

Shouldn't it also be possible to use native Windows functions to compress and uncompress groups of files into .zip-compatible archives? NOT "compress" like the command line .exe or operating system file attribute, but similar to how I can view/create compressed .zip-compatible files from Windows Explorer.

Bk
I'm sure it's entirely possible to use native Windows functions to compress and uncompress groups of files into .zip-compatible archives. The article justs shows one method there are probably many ways to do the same thing. When I was tasked with zipping files, I could find no real world examples so had to figure it out myself, as its something thats likely to be needed again I thought I would document the way I chose to do it.

Festeron
Oops well spotted I will change later...to
If Len(strDay) = 1 Then
strDay = "0" + strDay
End If

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists

Post #573701

« Prev Topic | Next Topic »

77 posts, Page 1 of 8

1 2 3 4 5 »»»

Permissions