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 an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Training Class in Waltham, MA October 6 - 8

This blog has moved! You can find this content at the following new location:

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



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement