SISS package gets corrupted while using custom dlls

Question

I've created a SSIS package (SQL Server Data Tools for Visual Studio 2013) for importing some data. Long story short, I need to embeed some dlls to be called in runtime using this method:

Embedding assemblies inside another assembly

Tried outside SSIS script component and is working.

Problem is, when you try to add a .dll as a resource the package gets corrupted and throws

Is there any workaround to use custom assemblies into a SSIS package without deploying them or fix this error?

Thank you

What dlls are you trying to add? Have you checked if the target framework of the dll is the as the script component? — colosso, Feb 20 '19 at 11:17
Custom dlls. Both dlls and script component using .Net 4.5.2 — Martín Notz, Feb 20 '19 at 11:24

score 0 · Answer 1 · answered Feb 25 '19 at 10:19

Looks like the problem is because the .dll is stored as bytes in the XML file of the package, and probably finds some character not allowed.

The workaround was transform that .dll into a Base64String, embeed it as a resource on the project and then do the way back.

SISS package gets corrupted while using custom dlls

1 Answers1