Packt Publishing recently published a book titled, Beginners guide to SQL Server Integration Services Using Visual Studio 2005.

The book provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. It will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.

What you will learn from this book?

Understand the Visual Studio 2005’s IDE as related to SSIS
Working with single and multiple tasks; working with more than 20 different tasks.
Connecting to Microsoft Access, Flat Files, Excel Spread Sheets and third party vendor product
Linking data source and data destination to a task
Learn how to send emails and ftp files
Transforming data from a source going to a destination
Using the scripting support that the IDE provides
Learn how to monitor the data as it is being transported also new in SQL 2005 Server
Learning about tasks such as web service and XML, which are new in SQL Server 2005
Understanding how to use and handle events

This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA’s who are testing water with the Visual Studio IDE but without a wide programming experience; SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services; Microsoft programming professionals in Small Businesses who wear multiple hats - developer, programmer, and dba with a little bit of experience in each of these.
It is expected that you know how to manipulate window objects, like clicking; dragging and dropping; using contextual help, tabbing, etc. It is also expected that you are exposed to SQL Server database basics and that you understand connecting to a database server; querying the database; reviewing objects; displaying and reviewing properties of objects, etc. Very little coding skill is assumed except that you can logically follow a fully commented code.

http:/www.packtpub.com/sql-server-integration-services-visual-studio-2005/book Click here for more information about the book
A sample chapter can be read here