SSIS Best Practices, Part 1

One of the topics on which I’ve presented quite a bit lately has been that of SQL Server Integration Services best practices. The body of knowledge on how to best use SSIS is small compared to more mature development technologies, but there is a growing number of resources out there related to SSIS best practices.

And here it is. 😉

In any event, here is a list of links to those online resources I have found related to SSIS best practices:

I’d also like to point out that there is a decent amount of overlap and a decent amount of contradiction between the various best practices referenced above. Not everyone agrees on what’s best, and to a large extent, “best” is determined as much by the context in which you’re using SSIS as it is by SSIS itself. Read all of these resources (and everything else, for that matter) with an open mind and apply their guidance with a healthy dose of pragmatism.

And although this doesn’t fall into the same “lists of things to do and to not do” category as the links above, anyone who is interested in doing SSIS correctly needs to check out Microsoft’s Project REAL ( as well.

Of course, I have no intention of stopping here. (The whole “Part 1” thing in the title probably clued you in on this already, right?) At some point – hopefully today, but possibly as late as this weekend – I will be posting my own personal list of best practices, but I wanted to give credit where credit is due before doing so.


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 Best Practices, BI, SSIS. Bookmark the permalink.

One Response to SSIS Best Practices, Part 1

Leave a Reply

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

You are commenting using your 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