Post reply

SSIS & Excel Manipulation

  • February 12, 2009 at 3:26 am

    #199920

    Hi, I need some help in developing a SSIS package.

    Basicly the package will have do the following things.

    1. Check if excel file with specific name exists at specified location.

    2. Change the name of the worksheet from Sheet1 to something else.

    3. Save the excel file with a new name to a new location.

    Can this be done programmatically?

  • February 13, 2009 at 7:56 am

    #943625

    anuragingle (2/12/2009)

    Hi, I need some help in developing a SSIS package.

    Basicly the package will have do the following things.

    1. Check if excel file with specific name exists at specified location.

    2. Change the name of the worksheet from Sheet1 to something else.

    3. Save the excel file with a new name to a new location.

    Can this be done programmatically?

    Hi,

    1. Where is the location of the excel file .. is it a file system location or a FTP location ...

    2 and 3 Check the file system task in SSIS.

    also check this out for file system task

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66719

    http://www.jumpstarttv.com/using-the-file-system-task-in-ssis_508.aspx

    Hope that helps ..

    Thanks,

    \\K 🙂

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • February 13, 2009 at 9:32 am

    #943734

    Thanks for the help SQL_Quest

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

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