THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns and Managing Geeks - A Journey of Leading by Doing, and author of the Stairway to Integration Services.

SSIS Training Class in Waltham, MA October 6 - 8

There are lots of things I love about training. I enjoy interacting with those enthusiastic to learn. I love watching the lights come on as students realize the solution to some issue they've battled. I really love hanging out with students durning breaks and after class - talking about ways to solve their ETL or data integration problems using SSIS!

I am honored to present From Zero To SSIS! in Waltham, MA October 6-8 in conjunction with Adam Machanic (Blog - @AdamMachanic) and his training company, Boston SQL Training. I believe the best way to learn SSIS is to get your hands on it as quickly and as much as possible. I designed this course to do just that.

First you learn the basics of SSIS. Next you learn how to load a data warehouse with SSIS. Then you learn troubleshooting, maintenance, and design patterns. I use real-world data for sources - not data generated in some lab. We hit real snags and overcome them. It's the most SSIS I can possibly pack into three days!

Visit Boston SQL Training for more information on From Zero To SSIS! I hope to see you there in October.


Published Tuesday, June 22, 2010 8:00 AM by andyleonard

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



Robert said:

Will, this training include creating custom components and programming against the SSIS APIs?

September 2, 2010 1:56 PM

andyleonard said:

Hi Robert,

  Unfortunately no. There's a course outline available here ( that describes the topics we will cover.

  I hope to see you there!

:{> Andy

September 2, 2010 2:01 PM

Robert said:

Thanks, I think someone from our team might be going.  

I did have a question about 2 C# projects I see called SSIS_ScriptComponent and SSIS_ScriptTask.  I have never used these projects before.  I have written Custom Components, but have never used these projects before.  Can you give me a little background on these projects?

September 2, 2010 2:04 PM

andyleonard said:

Hi Robert,

  Can you tell me where you find these two C# projects?

:{> Andy

September 2, 2010 9:41 PM

Robert said:

When you open Visual Studio 2008 and create a new project under C# SSIS_ScriptComponent and SSIS_ScriptTask appear.  When you create them they create a project.  The SSIS_ScriptTask gives a ScriptMain.cs.  The code in this class is similar to the code one can see when editting a Script Component inside a .dtsx package.  the SSIS_ScriptComponent project does not create any starting class.

September 3, 2010 9:48 AM

Leave a Comment


This Blog



Friend of Red Gate

My Company

Blog Roll

Check out the Linchpin People Blog...
Linchpin People Blog

Contact Me


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement