I haven't a clue what a dtsx package is (and happy to remain ignorant :-} ) - but good luck anyway...

>I'm eventually handling this in a dtsx package so hopefully I can add a script component that will handle that bit.
>>The TripleDes key needs a byte[] which is known at both ends. They are using MD5 to create the byte[] value from a shared string.....
>>
>>>Is that some sort of double layer of encryption ?
>>>
>>>They are MD5 encrypting the key then using that value to encrypt the actual data ?
>>>
>>>>>>>Hi
>>>>>>>
>>>>>>>I'm being passed some data encrypted with MD5.
>>>>>>>
>>>>>>>I can find examples of how I encrypt in TSql
>>>>>>>
>>>>>>>SELECT CONVERT(NVARCHAR(32),HashBytes('MD5', 'email@dot.com'),2)
>>>>>>>
>>>>>>>but I can't find an example of how I would de encrypt the result to get the original content.
>>>>>>
>>>>>>You can't - it's just a hash value....
>>>>>
>>>>>Hi Viv
>>>>>
>>>>>I'm being passed some data which I've been told is MD5 encrpted
>>>>>
>>>>>they've also passed me some c# code which has encryption and decryption functions.
>>>>>
>>>>>Is that not the same thing ?
>>>>>
>>>>>Nick
>>>>>
>>>>>
>>>>>using System;
>>>>>using System.Collections.Generic;
>>>>>using System.Linq;
>>>>>using System.Text;
>>>>>using System.Security.Cryptography;
>>>>>
>>>>>namespace Unified.ram.Common.Util
>>>>>{
>>>>> public class EncryptDecrypt
>>>>> {
>>>>> public static string Encrypt(string strToEncrypt)
>>>>> {
>>>>> string key = Sitecore.Configuration.Settings.GetSetting("EncryptDecryptKey", "");
>>>>> return Encrypt(strToEncrypt, key);
>>>>> }
>>>>>
>>>>> public static string Encrypt(string strToEncrypt, string strKey)
>>>>> {
>>>>> try
>>>>> {
>>>>> TripleDESCryptoServiceProvider objDESCrypto =
>>>>> new TripleDESCryptoServiceProvider();
>>>>> MD5CryptoServiceProvider objHashMD5 = new MD5CryptoServiceProvider();
>>>>> byte[] byteHash, byteBuff;
>>>>> string strTempKey = strKey;
>>>>> byteHash = objHashMD5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(strTempKey));
>>>>> objHashMD5 = null;
>>>>> objDESCrypto.Key = byteHash;
>>>>> objDESCrypto.Mode = CipherMode.ECB; //CBC, CFB
>>>>> byteBuff = ASCIIEncoding.ASCII.GetBytes(strToEncrypt);
>>>>> return Convert.ToBase64String(objDESCrypto.CreateEncryptor().
>>>>> TransformFinalBlock(byteBuff, 0, byteBuff.Length));
>>>>> }
>>>>> catch (Exception ex)
>>>>> {
>>>>> return "Wrong Input. " + ex.Message;
>>>>> }
>>>>> }
>>>>>
>>>>> public static string Decrypt(string strEncrypted)
>>>>> {
>>>>> string key = Sitecore.Configuration.Settings.GetSetting("EncryptDecryptKey", "");
>>>>> return Decrypt(strEncrypted, key);
>>>>> }
>>>>>
>>>>> public static string Decrypt(string strEncrypted, string strKey)
>>>>> {
>>>>> try
>>>>> {
>>>>> TripleDESCryptoServiceProvider objDESCrypto =
>>>>> new TripleDESCryptoServiceProvider();
>>>>> MD5CryptoServiceProvider objHashMD5 = new MD5CryptoServiceProvider();
>>>>> byte[] byteHash, byteBuff;
>>>>> string strTempKey = strKey;
>>>>> byteHash = objHashMD5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(strTempKey));
>>>>> objHashMD5 = null;
>>>>> objDESCrypto.Key = byteHash;
>>>>> objDESCrypto.Mode = CipherMode.ECB; //CBC, CFB
>>>>> byteBuff = Convert.FromBase64String(strEncrypted);
>>>>> string strDecrypted = ASCIIEncoding.ASCII.GetString
>>>>> (objDESCrypto.CreateDecryptor().TransformFinalBlock
>>>>> (byteBuff, 0, byteBuff.Length));
>>>>> objDESCrypto = null;
>>>>> return strDecrypted;
>>>>> }
>>>>> catch (Exception ex)
>>>>> {
>>>>> return "Wrong Input. " + ex.Message;
>>>>> }
>>>>> }
>>>>> }
>>>>>}
>>>>
>>>>Looks like that is using TripleDES for the encryption with a MD5 hash as the key ? No idea how you can go about decrypting in SQL tho :-{