How do I reference a custom .NET 4.0 DLL in script task?

dll ssis dts gacutil
victor picture victor · Jul 28, 2011 · Viewed 7.1k times · Source

I would appreciate any help in referencing a DLL from my SSIS script task. I created the DLL in Visual Studio 2010 and the SSIS package in Business Inteligence Development Studio 2008. I am running on WinXP. The DLL compiles successfully and can be used in a windows forms application. Below are the steps I did to register the DLL in GAC but still got a warning on SSIS Script task stating the DLL is not visible thus useless.

  1. Created key pair (sn -k ) in DLL project release folder.
  2. Signed the DLL by right clicking the DLL project(on visual studio) > select properties > Sign tab.
  3. Added the key pair.
  4. Build the project.
  5. Execute gacutil.exe (gacutil -i )

Below are my references(http://beyondrelational.com/blogs/niteshrai/archive/2010/04/13/referencing-an-assembly-inside-ssis-script-task.aspx)

I also read that SSIS in BIDS 2008 is not compatible with .Net framework 4.0 (Visual Studio 2010). Is their any truth in this?

Answer

user756519 picture user756519 · Jul 28, 2011

Yes, BIDS 2008 supports only .NET Framework 3.5 and not the .NET Framework 4.0. I would suggest that you compile your custom DLL to target .NET Framework 3.5, if you are not using .NET 4.0 functionality.

I have explained how to achieve this in a step-by-step example while answering the Stack Overflow question Why does SSIS fail to create this task? The example builds a custom DLL in VS 2010 but targets the .NET Framework 2.0.

Have a look at it. May be that will point you in the right direction.

Related questions

SSIS Script Task cant find reference to assembly

I have an SSIS package that uses a script task to populate a datatable with data from a variety of different file types including excel. I am using NPOI to read in the data from Excel and have put the …

Read More
How do I register a DLL file on Windows 7 64-bit?

I have tried to use the following code: cd c:\windows\system32 regsvr32.exe dllname.ax But this is not working for me. How can I register a DLL file on Windows 7 with a 64-bit processor?

Read More
PHP 7: Missing VCRUNTIME140.dll

I have an error when I start PHP 7 on Windows. When I run php on the command line, it returns a message box with system error: The program can't start because VCRUNTIME140.dll is missing from your computer. Try reinstalling …

Read More