Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

Once upon a time this blog was a hive of activity. Now however its pretty lifeless as you can probably tell so if are pining for more of the same you can find me over at http://sqlblog.com/blogs/jamie_thomson. I look forward to seeing you there!

SSIS: Online Beginner Resources

A common question on the SSIS forum is "I'm a beginner to SSIS, where can I go to learn more". Alternatively, many people ask very specific questions about how to accomplish their objectives in SSIS and in many ways they are trying to run before they walk. Its important to grasp the basics before trying anything too demanding and that, unfortunately, is the downside to using SSIS. There's quite a steep learning curve with it, particularly for people familiar with the forerunner, DTS.

I don't think there's any place where exists a single list of online resources so I thought I could supply one. The following are all useful sources of information for beginners:

SQL Server™ 2005: Integration Services Virtual Lab
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032286838&EventCategory=3&culture=en-US&CountryCode=US

Business Intelligence Upgrade Virtual Lab – Migrating Data Transformation Services (DTS) to SQL Server 2005 Integration Services
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032297337&EventCategory=3&culture=en-US&CountryCode=US

TechNet Webcast: Introduction to SQL Server 2005 Integration Services (Level 200)
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032289998&EventCategory=5&culture=en-US&CountryCode=US

The New ETL Paradigm
http://www.sqlservercentral.com/columnists/jthomson/thenewetlparadigm.asp

Creating a Simple ETL Package Tutorial 
http://msdn2.microsoft.com/en-us/library/ms169917.aspx

SQL Server Integration Services Articles from Marcin Policht
http://www.databasejournal.com/article.php/1503191

Introductory Videos from JumpstartTV
http://www.jumpstarttv.com/

Guided Tours
http://www.microsoft.com/sql/technologies/integration/tours.mspx

Do you know of any more? If so, let me know by posting a comment.

-Jamie

 

Published 30 January 2007 00:57 by jamie.thomson

Comments

 

Diane McNurlan said:

Microsoft SQL Server 2005 Integration Services by Kirk Haselden is an excellent resource for anyone learning about SSIS.  Lots of great tips, a chapter devoted to moving from DTS to SSIS and Kirk’s writing style makes it very easy to read.  I love the book so much, I have both the “dead tree version” and the pdf version!

January 30, 2007 01:20
 

jamie.thomson said:

Hi Diane,

Thanks for the comment. I would certainly agree that Kirk's book is the best off-line resource out there.

-Jamie

January 30, 2007 02:56
 

Jason Price said:

I stumbled upon this site recently http://www.jumpstarttv.com/ which has quite a few excellent tutorials.   The only problem for me is I can't access the videos from our company network.   BTW - I am in no way affiliated with the site...

February 2, 2007 14:42
 

jamie.thomson said:

Good one Jason. I completely forgot about Jumpstart. I've added it above.

-Jamie

February 2, 2007 16:44
 

SSIS Junkie said:

A few items related to SSIS have come to light over the past few days that are definately worth mentioning.

March 10, 2007 17:15
New Comments to this post are disabled

This Blog

Syndication

Powered by Community Server (Personal Edition), by Telligent Systems