1
kudos
spam Kudos Remove

SSIS – Unpack a ZIP file with the Script Task

published 886 days, 20 hours, 4 minutes ago posted by sasa 893 days, 17 hours, 2 minutes ago
Thursday, September 03, 2009 5:28:42 PM GMT Thursday, August 27, 2009 8:31:09 PM GMT

A while ago I needed to unpack a couple of zip files from SSIS. There is no Microsoft SSIS task that contains this functionality so I searched the Internet. It seems that there are quite some third party tools that offer this functionally. It's also possible to download custom SSIS tasks. I personally always try to avoid third party tools and custom tasks so I searched on. It seemed there is a way to unzip files from SSIS with the Script Task. With some Visual Basic code using the Visual J# Library you ...

category: Warehousing | clicked: 7 | | source: sqlblogcasts.com | show counter code
tags: Expressions, Script Task, SQL Server 2008, SQL Server Integration Services, SSIS, Unpack zip file, Unzip, VB .NET, vjslib.dll

No comments yet, be the first one to post comment.

To post your comment please login or signup