compressed(zipped) folder

• Bindhu-467107

  Newbie

  Points: 3

  More actions

  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.

• Bob Fazio

  SSChampion

  Points: 10794

  More actions

  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

• daniel

  Mr or Mrs. 500

  Points: 581

  More actions

  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