Click here to Skip to main content
13,450,489 members (54,778 online)
Click here to Skip to main content
Add your own
alternative version


15 bookmarked
Posted 8 Oct 2006

Access .NET assembly through SSIS (Script Component)

, 8 Oct 2006
Rate this:
Please Sign up or sign in to vote.
Here is some cool stuff to call .NET assembly from SSIS
<!-- Article Starts - DO NOT ADD HTML/BODY START TAGS-->


Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>


Here is some cool stuff to call .NET assembly from Script Component of SSIS.<o:p>

Remember whenever we use “Script Component” while developing SSIS application, by default we get list of assembly on click of “Add Reference” from default path …Microsoft.NET\Framework\v2.0.50727, as shown below, <o:p>

Sample screenshot

Now question is how to call any business logic (Included in .NET assembly) from Script Component…? <o:p>

I would say put physically that assembly (Which needs to be referenced) at …Microsoft.NET\Framework\v2.0.50727. But I believe this would be just a work around not a proper solution. <o:p>

What follows is another approach to accustom described functionality,<o:p>

1.      Import “System.Reflection” assembly in Script Component<o:p>

2.      Add assembly (Which need to be referenced) in GAC<o:p>

3.      Write following code to call external assembly from your own Script Component of SSIS.<o:p>


//Define variable of type [Assembly]  <o:p>

Dim targetAssembly As [Assembly] = Nothing<o:p>

//Load assembly named “CallBySSIS” from GAC into defined variable  <o:p>

targetAssembly = [Assembly].LoadWithPartialName("CallBySSIS")<o:p>

//Define variable which used to hold “Type” object<o:p>

Dim targetType As Type<o:p>

//Get specific class from assembly here “clsTest”<o:p>

targetType = targetAssembly.GetType("CallBySSIS.clsTest")<o:p>

//Define variable of type Object<o:p>

Dim objClsTest As Object<o:p>

//Get instance of “clsTest” into defined variable<o:p>

objClsTest = targetType.InvokeMember("clsTest", BindingFlags.CreateInstance,   Nothing, Nothing, Nothing)<o:p>

//Now you are free bird to call function of class “clsTest” named //“writeToFile(String strMessage)”<o:p>

objClsTest.writeToFile("Colour Dataflow : " + ex.Message) <o:p>

4.      Add “option Strict Off” on the top of script component; else compile time error for casting will occur.<o:p>

I hope this article will save SSIS developers life, since it shows path how to use complex logic written previously.      <o:p>



This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Malpani Amol
Web Developer
India India
I am a .NET developer cum designer. I work for Zensar Technologies Ltd. Pune (INDIA), I consult, I develop, I debug and besides that I speak at conferences and user groups and I also write. I have written some articles on WCF, WF, SSIS, Compression decompression, CLR Store Procedure, SQL Server Reporting Services 2005, Extended grid and lot more to count.
Reach to me

You may also be interested in...

Comments and Discussions

Generalfaster extraction and loading on SSIS. Pin
blackpower2k725-Apr-09 19:54
memberblackpower2k725-Apr-09 19:54 
QuestionAdding External Library Pin
Sith Kong27-Jun-08 3:15
memberSith Kong27-Jun-08 3:15 
GeneralOther solution Pin
vincent19763-Jan-07 8:13
membervincent19763-Jan-07 8:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.180318.3 | Last Updated 8 Oct 2006
Article Copyright 2006 by Malpani Amol
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid