Hi there. This sounds like an SSIS (Integration Services) question and not a SQLCLR question. If so, there is probably a more appropriate forum that will get this answered much faster.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR