I've been enjoying quite a lot a series of articles on databasejournal.com [1] by Marcin Policht that introduce various elements of SQL Server Integration Services (SSIS). Each article is short, concise, clear, and contains good examples and illustrations. I usually avoid these kind of big-media IT sites like the plague because there is more advertising than content (and because I hate the way these big companies in the early 2000's purchased and then ruined so many good technology sites--but that's another story). However, this Database Journal site regulary publishes some good articles (RSS feed here [2]).
Ironically, though, their own site does not contain a good directory of this full series of SSIS articles. So here it is. I think this may be--at this moment, before the wave of SSIS books hits the market--the closest thing we have to an introductory SSIS book:
SQL Server Integration Services - Part 1 (Basic Concepts) [3]
SQL Server Integration Services - Part 2 (Basic Examples) [4]
SQL Server Integration Services - Part 3 (Package Maintenance) [5]
SQL Server Integration Services - Part 4 (Variables and Expressions) [6]
SQL Server Integration Services - Part 5 (Foreach Containers) [7]
SQL Server Integration Services - Part 6 (Foreach Containers Continued) [8]
SQL Server Integration Services - Part 7 (Foreach Nodelist Container) [9]
SQL Server Integration Services - Part 8 (Foreach Item Container) [10]
SQL Server Integration Services - Part 9 (WMI Data Task) [11]
SQL Server Integration Services - Part 10 (WMI Event Task) [12]
SQL Server Integration Services - Part 11 (SSIS Events and Event Handlers) [13]
SQL Server Integration Services - Part 12 (Logging) [14]
SQL Server Integration Services - Part 13 (Debugging) [15]
SQL Server Integration Services - Part 14 (Debugging Data Flow) [16]
SQL Server Integration Services - Part 15 (Debugging Script Component) [17]
SQL Server Integration Services - Part 16 (Data Flow Script Component) [18]
SQL Server Integration Services - Part 17 (Script Transformation Component) [19]
SQL Server 2005 Integration Services - Part 18 (Destination Script Component) [20]
This one is apparently not in the numbered article series:
SQL Server Integration Services - Loop Containers [21]
This series keeps growing, so check the Database Journal site for new articles if my list falls out of date.
Dan