Post reply

zip folder

  • December 6, 2010 at 10:56 am

    #231902

    Hi friends,

    I am having zip folder at one location.Under that zip folder there are number of .txt files.I have to move all .txt files from that location to another location.

    I want to do this by using ssis package as well schedule on that.and i have to remove 3 days old files from the destination.

    Please help me.

    Thanks in advance

    Abhas.

  • December 6, 2010 at 12:22 pm

    #1259171

    I have never done it before, but I'm pretty sure you can unzip files with a script task. There will already exist some .NET code on how to do this on the net.

    Moving the files can be done with a for each loop container, which loops over the .txt files. Inside the container you can place a File System Task or a script task, whatever you feel most comfortable with.

    Removing the 3 days old files can also easily be done with a script task (see the FileInfo and DirectoryInfo methods in .NET).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 7, 2010 at 5:34 am

    #1259472

    Hi Thanks for suggestion.

    Can u plz explore it by small example?

Viewing 3 posts - 1 through 2 (of 2 total)

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