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!

Get Expert SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.