How to use SSIS to update records in an Excel file?

How to use SSIS to update records in an Excel file?  Thanks.
thomaszhwangAsked:
Who is Participating?
 
cheers4beersCommented:
You could pull the data into a temporary table (or have a table permanently set up to work with the data), make the necessary updates, and push it back to the Excel file.  Or, you could use an Active-X script task.  How much formatting is there in the Excel file?  What kinds of updates would be made?
0
 
thomaszhwangAuthor Commented:
Thanks.
0
 
SiddharthRoutCommented:
I know this has been solved but you might want to have a look at this tutorial?

Topic: SSIS: Export data from Sql Server 2005 to Excel
Link: http://cavemansblog.wordpress.com/2009/04/17/ssis-export-data-from-sql-server-2005-to-excel/

Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.