Unable to reference Custom Class library in SSIS Script Component

scott goodwin 1 Reputation point
2020-09-11T00:02:43.583+00:00

I have a .Net Standard 2.0 Class Libary which I am unable reference in my SSIS Script Component. I am using Visual Studio 2019.

The Library has the following settings.

24011-image.png
Whenever the script references the library I get an error indicating the library or one of its dependencies coudl not be loaded. The only dependencies it has are:

23952-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,450 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,891 Reputation points
    2020-09-11T02:42:39.003+00:00

    Hi @scott goodwin ,

    Using a Managed Assembly

    For Integration Services to find a managed assembly at design time, you must do the following steps:

    1.Store the managed assembly in any folder on your computer.
    2.Add a reference to the managed assembly.
    To add the reference, in VSTA, in the Add Reference dialog box, on the Browse tab, locate and add the managed assembly.

    Please refer to the following links:

    Tutorial: Create a .NET Standard library using Visual Studio

    Referencing Other Assemblies in Scripting Solutions

    Using Custom DLL's in an SSIS Script Task

    Best Regards,
    Mona


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.