Learn how to call a method defined in a dotnet assembly

Open Visual studio, and create a new class library project and name the class file as TestLibrary and add a method called ReverseString which will take an input string and will return the reverse of that.

Next step is in order to use this dll in SSIS we need to put this assembly in GAC so sign it with a strong name key and deploy it in GAC either by drag and drop or by using the Global Assembly Cache Tool (Gacutil.exe).

Add a script task on to the SSIS design window.

Double click on it to open the script task editor, click on Edit Script button to enter into the script task code editor.

On the solution explorer right click on the reference, add reference to the class library which we created.

How to call a .Net assembly in SSIS