blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

SSIS Junkie

Conchango are busy and need talented consultants in and around London. Interested? Email me or send me a message

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

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

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

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