"SSIS Packet Componentization" Article on Simple-Talk

Ok, so I’m pretty sure they mean "Package" and not "Packet" but there is a great article by David Leibowitz (the SQL guy, not the pastry chef) on designing modular SSIS packages on the Simple-Talk web site – check it out here: http://www.simple-talk.com/content/article.aspx?article=500.

I’ve long been a proponent of the "one table per package" design pattern[1] in SSIS, but I’ve never seen such a coherent and comprehensive writeup online that covers both what to do and why to do it. I don’t know if I agree with everything that David has to say, but all in all it’s a good read with downloadable code as well. Make sure you check it out.


[1] Yeah, it’s not much as design patterns go, but I do think that it qualifies.


About ssimagine

My name is Matthew Roche, and I am a Senior Program Manager with the SQL Server product group at Microsoft. I work on Master Data Services and Data Quality Services, and have previously worked on SQL Server Integration Services. Although I work for Microsoft and will be posting on technical topics, I want to stress that this is a personal blog, and any opinions posted here are mine and mine alone. I built my career around SQL Server and Microsoft technologies for well over a decade before I joined Microsoft as an employee, and I plan on using this blog to share my personal experience and opinions. They may well be shaped by my experience on the SQL Server team, but they’re still mine, and not that of Microsoft, disclaimer, disclaimer, etc., etc..
This entry was posted in BI, SQL Server, SSIS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s