Post reply

compressed(zipped) folder

  • July 20, 2007 at 4:00 pm

    #721294

    Hi, do you have any idea how to do the same i.e. collect zip files from FTP sites (UNIX environment) and then unzip them using SSIS. I have difficulty in making the zip file name dynamic using FTP task in SSIS. Could you please suggest,or could you give a snippet of the code you had written for the DTS package.

  • July 24, 2007 at 7:09 am

    #721886

    Another option is to write a perl wrapper program.  You can also use VB Script.  Since this is SSIS, I am going to assume SQL Server 2000.  If it was 2005 you could use CLR

  • July 25, 2007 at 8:39 am

    #722322

    I also use WinZip with the command line ad-in, and then shell to it.

    But if I had to do without it, I would look into the J# (Java.NET) classes.

    http://msdn.microsoft.com/msdnmag/issues/03/06/ZipCompression/default.aspx

     


    MISfIT

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply