Post reply

Emailing contents of a folder or the folder itself using SSIS or VB.Net within a Script Task

  • May 31, 2011 at 2:24 am

    #150234

    Hi all

    I have a folder that contains around ten .xls files. I would like to email these .xls files to an individual. What I would like to know is how to email the contents (.xls files) or just simply email the folder itself.

    How can I do this using VB.Net within a Script Task, or using another method through SSIS?

    It will probably be a good idea to zip the folder contents first. How can I zip the folder in SSIS using VB.Net??

    And one final question, is there a way to merge all .xls file into one workbook so each original .xls file is a worksheet in the new workbook???

    Thank you in advance.

  • May 31, 2011 at 8:23 am

    #1332008

    I have solved this now to the extent where I have achieved the first two parts but not the third. No need to respond. Thanks.

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

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