Thursday, February 19, 2015

How to reference a .DLL in script task in a SSIS package

 

 

step 1: create the .NET project and build it

Step 2: Sign  and rebuild

Step 3: Deploy to the GAC global assembly Cache  use GACUTIL  located at c:\windows\system32

Step 4: when to deploy to Target SSIS machine, try drag and drop the DLL into c:\windows\assembly or if it's .Net 4 in C:\Windows\Microsoft.NET\assembly\****\

 

Reference article:  http://microsoft-ssis.blogspot.ca/2011/05/referencing-custom-assembly-inside.html#comment-form