SQL 2005 SSIS How-To Article Series

Submitted Fri, 2006-02-10 19:10

I've been enjoying quite a lot a series of articles on databasejournal.com 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).

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)

SQL Server Integration Services - Part 2 (Basic Examples)

SQL Server Integration Services - Part 3 (Package Maintenance)

SQL Server Integration Services - Part 4 (Variables and Expressions)

SQL Server Integration Services - Part 5 (Foreach Containers)

SQL Server Integration Services - Part 6 (Foreach Containers Continued)

SQL Server Integration Services - Part 7 (Foreach Nodelist Container)

SQL Server Integration Services - Part 8 (Foreach Item Container)

SQL Server Integration Services - Part 9 (WMI Data Task)

SQL Server Integration Services - Part 10 (WMI Event Task)

SQL Server Integration Services - Part 11 (SSIS Events and Event Handlers)

SQL Server Integration Services - Part 12 (Logging)

SQL Server Integration Services - Part 13 (Debugging)

SQL Server Integration Services - Part 14 (Debugging Data Flow)

SQL Server Integration Services - Part 15 (Debugging Script Component)

SQL Server Integration Services - Part 16 (Data Flow Script Component)

SQL Server Integration Services - Part 17 (Script Transformation Component)

SQL Server 2005 Integration Services - Part 18 (Destination Script Component)

This one is apparently not in the numbered article series:
SQL Server Integration Services - Loop Containers

This series keeps growing, so check the Database Journal site for new articles if my list falls out of date.

Dan

» Daniel Read's blog | login to post comments | printer friendly version

Categories: SQL Server 2005 | SSIS (SQL Server Integration Services)

You're a mensch

Comment submitted by Andy Tegethoff on Thu, 2006-02-16 15:19

I'm not even using SQLServer now, but it's worth noting that you're El Hombre for doing their work for them. Looking at the comments for your blog entries on this topic clearly indicates that it's a bit of a blind spot. Good on ya, as usual.

» login to post comments