This is one of those areas where you'll be richly rewarded by first learning the theory before learning a particular tool stack.
The twin bibles of data warehousing theory are Bill Inmon's Building The Data Warehouse and Ralph Kimball's The Data Warehouse Toolkit. There's a lot of platform-war kerfuffle amongst BI insiders who treat these like religious texts. Stay out of that as much as you can...the fight is more about personal style than technical correctness.
Bird's-eye view, I'd recommend going with Inmon if you're a "measure twice, cut once" type of developer who likes to plan carefully, then build. Conversely, I'd recommend Kimball if you like to jump in feet first and start prototyping.
Either one of these books will serve perfectly well to teach you the basics of BI theory and practice.
After that, since your primary interest is in SSIS - the ETL component in Microsoft's stack - I'd recommend Kimball's The Data Warehouse ETL Toolkit. This will teach you why you're doing ETL and what the common practices are. You could potentially skip the first two recommendations and jump straight to this one if you thrive on a steeper learning curve, but I strongly recommend attacking this book before doing a Microsoft-specific one.
From there, there are half a dozen books about SSIS 2008 specifically, or you could get The Microsoft Data Warehouse Toolkit. All of these have Kindle editions, as do the SSIS-specific books from most publishers (Wrox, Wiley, etc.)