Code Reference A collection of code for my reference (and perhaps other people too)

Using external libraries in a SSIS Script Component

I found myself needing to encrypt a column of data in a SSIS package.
I added a Script Component that would take one field from the database and return the same field encrypted.
The library that does the encrypting was not written in Visual Studio. It was created in Power Basic I think.

Normally, you would just import the library using DLLImport and run the method you need. Like this:

private const string MYENCRYPTOR = @"C:\Encrypt.dll";

[DllImport(MYENCRYPTOR, EntryPoint = "ENCRYPTMYID", SetLastError = true, CharSet = CharSet.Ansi)]
private static extern string EncryptMyId(int myId);
...
...
...
string encryptedId = EncryptMyId(id);

This works in a normal project, but for some reason I do not know, it will not work in an SSIS package.
To fix this, I created a Console Application wrapper for the encrypt method.
The console application accepts the ID as an input variable and returns the encrypted ID as a string.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;
using System.Diagnostics;

namespace ExcryptThis
{
    class Program
    {
        private const string MYENCRYPTOR = @"C:\Encrypt.dll";

        [DllImport(MYENCRYPTOR, EntryPoint = "ENCRYPTMYID", SetLastError = true, CharSet = CharSet.Ansi)]
        private static extern string EncryptMyId(int myId);

        static void Main(string[] args)
        {
            string sId;
            if (args.Count<string>() > 0)
            {
                sId = args[0];

                try
                {
                    int id = Convert.ToInt32(sId);
                    string encryptedId = EncryptMyId(id);
                    Console.Write(encryptedId);
                }
                catch (Exception ex) { }
            }
        }
    }
}

Note: be sure to use a Console.Write and not a .WriteLine or you will add a "\r\n" at the end of the returned value.

Then, in the SSIC Script Component, I call the console application as I described in my previous post.

Wrapped in the console application it runs fine.