Add third party dll reference in ssis script component

by

By “Running,” I assume running from agent/command-line is failing? It should work from within BIDS/SSDT. The short answer is the DLL must be registered with the GAC or you can download the source code and add that project into the script task and then reference said project.

Looking at the project, it should be a strongly signed DLL (based on presences of Dynamic.snk) and thus capable of being added to the GAC. Oh, but you state you will not be able to add it into the GAC, implying it’s a permission not a capability issue.

If that’s the case, either compile the project in with the source or surround it with a web service wrapper and then reference the service.

I also saw this answer, seems you can try loading the references dynamically.

More Related Contents:

  1. Taking lot of time to read from SQL Server using c#
  2. System.IndexOutOfRangeException: Cannot find table 0
  3. i Want the following conversion for the table
  4. I want to insert a record in DB and then need to return a row
  5. Read data from SqlDataReader
  6. How do I clean SqlDependency from SQL Server memory?
  7. Adding multiple parameterized variables to a database in c#
  8. Executing SSIS 2012 package that has script components from external application
  9. Format of the initialization string does not conform to specification starting at index 0
  10. Encrypt connection string in app.config
  11. export to Excel from a list with EPPLUS
  12. How to connect to database from Unity
  13. How to execute an SSIS package from .NET?
  14. What is the right way to populate a DropDownList from a database?
  15. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  16. SQL WHERE clause matching values with trailing spaces
  17. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  18. How to pass User Defined Table Type as Stored Procedured parameter in C#
  19. SqlParameter does not allows Table name – other options without sql injection attack?
  20. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  21. How to access ssis package variables inside script component
  22. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  23. Syncing SQL Server 2008 Databases over HTTP using WCF & Sync Framework
  24. get date part only from datetime value using entity framework
  25. Reverse engineering SSIS package using C#
  26. Calling SQL Defined function in C#
  27. Passing datatable to a stored procedure
  28. 3 Digit currency code to currency symbol
  29. VS 2015 SSIS Script Tasks cannot be debugged
  30. SSIS Script Task cant find reference to assembly

Leave a Comment