thomaszhwang
asked on
How to use SSIS to update records in an Excel file?
How to use SSIS to update records in an Excel file? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think you may need to use a Script Task. See here:
http://www.databasejournal.com/features/mssql/article.php/3919016/Accessing-Excel-Via-ADONET-Using-SSIS-Script-Task.htm
http://www.ehow.com/how_7499559_delete-using-ssis-script-task.html
http://www.databasejournal.com/features/mssql/article.php/3919016/Accessing-Excel-Via-ADONET-Using-SSIS-Script-Task.htm
http://www.ehow.com/how_7499559_delete-using-ssis-script-task.html
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
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
ASKER