Chapter 10. Handling Heterogeneous and Unusual Data
Because of its price-point (out of the box with SQL Server 2005), SSIS is not only being used to push data into SQL Server, but also to heterogeneous sources. On the other side of the coin, you will often receive data that's not anywhere close to perfect that you must transform with SSIS. This chapter walks you through some of the scenarios witnessed in the field, that kept us up late at night. These examples should cover most scenarios that you'll see in your company, and will hopefully keep you from having to have the same sleepless nights that we had while creating these solutions!