Processing Excel files in SSIS 2008 – Lessons Learned

I have recently been working on a project where we need to load and transform data held in Excel 2007 into a SQL Server database.  The Excel sheets were fairly complex and had different structures.  Fortunately, SSIS 2008 provides some good tools to handle this situation.  Lessons learned 1. It is possible to read the…

1