Post reply

Open excel 2007 file and refresh all data, rename file with actual datetime, copy file to destination folder.

  • January 26, 2009 at 3:53 am

    #204535

    Hi,

    Is it possible to use integration service in order to open excel 2007 file, then to refresh all data (pivot tables ), rename file with current datetime and finally to save file to specific destination. Which task to use and how?

  • January 26, 2009 at 7:03 am

    #932575

    Jagger (1/26/2009)

    Hi,

    Is it possible to use integration service in order to open excel 2007 file, then to refresh all data (pivot tables ), rename file with current datetime and finally to save file to specific destination. Which task to use and how?

    You have to implement script task and use the Excel interop and API to build your process. However keep in mind that you may end up with the process still not working because Excel requires user profiles for the API and the SQL Job Agent starts light-weight processes which doesn't load user profiles. Having said that my point is that you will probably waste your time and in the end it will most probably not work.

    Check these posts to find out what kind of problems you may expect with Excel automation:

    http://www.sqlservercentral.com/Forums/Topic631234-148-2.aspx

    http://www.sqlservercentral.com/Forums/Topic635156-148-1.aspx

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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