SSIS Resources

January 29, 2009 · 3 comments

***UPDATED 2/10/2009 – Added links***
***UPDATED 2/23/2009 – Added MSDN SSIS Forum and Jeff Wharton’s link list.***

Last Thursday I gave a talk at the Oregon SQL Server Developers Professional Association and promised to post some Integration Services resources.

SSIS Best Practices

SQLCAT – Top 10 SQL Server Integration Services Best Practices
Matthew Roche – SSIS Best Practices, Part 2
Jamie  Thomson – SSIS: Suggested Best Practices and naming conventions

SSIS Tools and Samples

BIDS Helper is a very useful add-in for Visual Studio. Works with both SQL Server 2005 and 2008. Version 1.4 was just released on Jan 27th.

PacMan – batch package management tool by Matthew Roche.

Integration Services Product Samples

SSIS Blogs

Andy Leonard
BI Polar – Matthew Roche
BI Thoughts and Theories – John Welch
Brian Knight
Chris Randall
Dougbert.com – Douglas Laudenschlager
Jessica M. Moss
John Klein’s Microsoft Business Intelligence Blog
Michael Entin’s Notebook
Rafael Salas
Rushabh Mehta
SQLIS.com
SSIS bits ‘n’ bobs BLOG – Paul Ibison
SSIS Junkie – Jamie Thomson
SSIS Talk – Phil Brammer
SSIS Team Blog

I’ve shared an opml file of all the SSIS blogs if you would like to import them into an aggregator such as Google Reader.

Microsoft Links

MSDN: SQL Server 2008 – Integration Services
MSDN: SQL Server 2005 – Integration Services
Product page: SQL Server 2008 – Integration Services
Product page: SQL Server 2005 – Integration Services
MSDN: SQL Server Integration Services Forum

Other Links

Jeff Wharton – Favourite SQL Server Integration Services Articles

{ 3 comments… read them below or add one }

Matt M February 2, 2009 at 2:41 am

Nice collection – thx!

douglasl February 9, 2009 at 11:47 pm

Rob, Nice of you to mention my blog on dougbert.com. I hope that you and your PASS colleagues have noticed how dramatically we've transformed the Integration Services page on MSDN/TechNet: http://msdn.microsoft.com/en-us/sqlserver/cc51147… In addition to the frequent updates and community focus, there are RSS feeds so you'll never miss another new SSIS white paper or download. Maybe I'll have a chance to visit your group on a future visit to Portland. Best wishes, -Doug

Rob Boek February 10, 2009 at 5:30 pm

Doug,

Thanks for the link. I updated the post. Definitely check out the Oregon SQL Dev group if you get a chance. Let me know if you are going to attend.

Leave a Comment