Text file from FTP connection is now a *.zip file
-
Hello all. I have a package that downloads a text file from an FTP server. However, this file is now a zipped file. After the FTP task, there is data flow task that uses a flat file source. Of course, now that file does not exist because it has a .zip extension instead of .txt.
I have been to sites trying to figure out how to unzip the flat file, and this site seems the most helpful: http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx
The problem I'm stuck at now is that I downloaded and ran the Microsoft Visual J# Redistributable Package, but when I add the "Imports java.util.zip" to the declarations portion of the script, I get the error "Namespace or type specified in the Imports java.util.zip doesn't contain any public member or cannot be found."
It seems I have to do something for VB to recognize the java namespace, but I don't know enough it to even know where to start.
Also, if someone has a completely different (read, easier) solution to unzipping a text file, I'll certainly take it.
Thank you for any help in advance.
Amy
-
I did figure out how to add a reference, but will still take easier methods for reading a zip file in SSIS.
-
Amy.G (3/12/2012)
I did figure out how to add a reference, but will still take easier methods for reading a zip file in SSIS.Hello Amy,
If you can use third-party solutions, check the commercial CozyRoc Zip Task. It is very easy to use and it doesn't require programming skills.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply