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…

Date Time Formats

Many DateTime formats are available. We use the ToString method on the DateTime type. ToString receives many useful formats. These formats have confusing syntax forms. Correct formatting of dates and times is essential to many programs. DateTime Format string To start, we see an example of how you can use a specific formatting string with…