Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
MSBI 6
SSIS 4
BRH 2
#BI 2
#SSRS 1
SSRS 1
whitepapers 1
#SSAS 1
#POWERPIVOT 1
PowerPivot 1

Archive · View All
August 2010 3
April 2010 3

Referencing an assembly inside SSIS script task

Apr 13 2010 1:12AM by Nitesh Rai   

Let's see how to add an assembly inside SSIS script task. At first, create a simpe class library without any code and build it. I have copied my dll from the default location to D:\SampleTest\CustomAssembly. Then add a script task to a new ssis package and open the script task's editor and try to add the new assembly from the above path. Following figure shows how to add an assembly in a script task:

After selecting "Add Refernce" option, unfortunately there is no assembly with name  "CusotmAssembly.dll". To make the things more worse, there is no browse button so that we can browse to the path and add the asembly. This is because "Add Reference" option will expose only those dll's which are added to global assembly cache (GAC). An assembly can be added to GAC using gacutil.exe which can be executed from command line as shown:

Above figure suggests that the assembly should be strong named before adding to GAC. Check this link for strong naming an assembly. Once the assembly is given a strong name, try to add it to GAC again and this time it should get added successfully. Now, go and add a reference to the new assembly in script task  and check if the newly added assembly is available/visible or not. If it is not there then copy the assembly to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727. Now the CustomAssembly.dll should be visible inside script task.

To conclude: Inorder to add a custom assembly to a scrip task or script component in an  SSIS package, we need to

  • Strong name the assembly
  • Add the assembly to GAC
  • Copy the assembly to C:\WINDOWS\Microsoft.NET\Framework\<version>

Tags: MSBI, SSIS, Adding_assembly_SSIS_scripttask, Custom_assembly_InSSIS, Adding_assembly_SSIScriptcomponent, Adding_assembly_toSSIS,


Nitesh Rai
138 · 1% · 361
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

2  Comments  

  • I think adding assembly to the GAC would be sufficient.

    commented on Apr 13 2010 7:03AM
    ,
    168 · 1% · 293
  • Hi Siddharth, Thanks for the comment. I was also under the same impression that adding into GAC after strong naming will do the job but it is not always the case. Thats why I mentioned "If it is not there...". Infact I was stuck on this point while doing a POC for some client and after some serious search using my fav search engine I got this trick (or whatever you say) and thought of putting it altogether : )

    commented on Apr 13 2010 8:00AM
    Nitesh Rai
    138 · 1% · 361

Your Comment


Sign Up or Login to post a comment.

"Referencing an assembly inside SSIS script task" rated 5 out of 5 by 1 readers
Referencing an assembly inside SSIS script task , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]