How to load an Assembly in a SSIS script task that isn’t in the GAC

The documented and recommended way to reference a custom assembly from an SSIS Script Task or Script Component is to install it in the Global Assembly Cache (GAC).  However this is not always possible or simple to do. Here’s a simple workaround for loading an assembly from an arbitrary location.  The idea is to register…

26

Compatible Encryption/Decryption for Windows Store Apps and Full .NET Framework

I recently needed to encrypt some data in a Windows Store App and decrypt it on the server in a full .NET Framework application.  The Encryption APIs available in the two environments are different, so I came up with the following class that implements a compatible pair of encryption and decryption functions to enable encrypting…

1

New Sample Published: ObjectDataReader

I just published a new sample in the MSDN sample gallery:  ObjectDataReader.  This is an update of an older sample (EntityDataReader) that is an IDataReader adapter for object collections.  This is useful primarily for bulk loading SQL Server from a collection of .NET objects. ObjectDataReader is intended to be simple and fast.  It uses dynamically-compiled expressions to…

0