Post reply

daily package for zipped file

  • September 5, 2012 at 2:29 pm

    #147304

    How i can create a package to download file from website which is in zipped format then i have to load that file after unzipp to the table?. I have a website where every day new file come they just change the file name by changing the date in filename(like for today file name will be "center_2012_05_09.csv.gz" and tomorrow it will be "center_2012_06_09.csv.gz").I have to create a package which first should load the file in some folder then it should unzip that file and it should load that .csv(unzip) file to my table.How we can do that in ssis?.

  • September 5, 2012 at 8:40 pm

    #1534212

    I found this site to be very helpful with regards to zipped files.

    Regards:
    Mordred
    Keep on Coding in the Free World

  • September 6, 2012 at 11:45 am

    #1534671

    thanks

  • September 7, 2012 at 7:31 am

    #1535058

    I get zip files ftp'd in daily and use an execute process task in SSIS to run the 7-zip executable and unpack them. The file and destination details are passed as variables which are set by a preceeding script task which can use vb code to deal with checking and parsing the date in the filename which is similar to yours.

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

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