How do you refresh Excel spreadsheets using SSIS?


  • We want to be able to refresh our Excel 2007 spreadsheets after we rebuild a SSAS cube.  We already have a SSIS package set up to rebuild our cubes.  It would be nice if we could add a SSIS task or data flow that will refresh speadsheets as part of our batch process at night.  Any suggestions would be appreciated.  Thanks.

    Thursday, September 25, 2008 6:14 PM


All replies