关于SSIS中解密数据库字符串的方法

 public static string GetConDb(string filter, string Dbname)
    {
        string Reaconn = "";
        string constr = "Data Source=.;Initial Catalog=IBBC;Integrated Security=SSPI;";
        string sqlstr = "SELECT * FROM IBBC.dbo.Table_1 where temp1='"+filter+"' and  temp2='"+Dbname+"'";
        SqlConnection con = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(sqlstr, con);
        con.Open();
        try
        {
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                //此处获取对应的整个sql身份验证的连接字符串
                string bb = sdr[1].ToString();
                string[] connecstr = bb.Split();
                for (int i = 0; i < connecstr.Length; i++)
                {
                    //判断是否匹配到数组中的的密码
                    if (connecstr[i].Contains("Password"))
                    {
                        //获取带密码的字符串长度，比如：Password=Xeferfa0=长度为18
                        int GrossPwdlth = connecstr[i].Length;
                        //获取Password=后面的加密字符
                        string RevertoldPwd = connecstr[i].Substring(9, GrossPwdlth - 9);
                        //将获取到的密码密文进行解密
                        string newpwd = DecryptDES(RevertoldPwd, UUkey);
                        //将密文密码替换成明文密码
                        bb = bb.Replace(RevertoldPwd, newpwd);
                    }
                   
                }
                Reaconn = bb;
            }
            return Reaconn;
        }
        catch (Exception ex)
        {

            throw new Exception(ex.Message); ;
        }
        finally 
        {
            con.Close();        
        }      
    }

    private static byte[] Keys = { 0x12, 0x34, 0x56, 0x78, 0x90, 0xAB, 0xCD, 0xEF };
    //密钥
    private static string UUkey = "********";
    /**/
    /**/
    /**/
    /// <summary>
    /// DES加密字符串
    /// </summary>
    /// <param name="encryptString">待加密的字符串</param>
    /// <param name="encryptKey">加密密钥,要求为8位</param>
    /// <returns>加密成功返回加密后的字符串，失败返回源串</returns>
    public static string EncryptDES(string encryptString, string encryptKey)
    {
        try
        {
            byte[] rgbKey = Encoding.UTF8.GetBytes(encryptKey.Substring(0, 8));
            byte[] rgbIV = Keys;
            byte[] inputByteArray = Encoding.UTF8.GetBytes(encryptString);
            DESCryptoServiceProvider dCSP = new DESCryptoServiceProvider();
            MemoryStream mStream = new MemoryStream();
            CryptoStream cStream = new CryptoStream(mStream, dCSP.CreateEncryptor(rgbKey, rgbIV), CryptoStreamMode.Write);
            cStream.Write(inputByteArray, 0, inputByteArray.Length);
            cStream.FlushFinalBlock();
            return Convert.ToBase64String(mStream.ToArray());


        }
        catch
        {
            return encryptString;
        }
    }
    /**/
    /**/
    /**/
    /// <summary>
    /// DES解密字符串
    /// </summary>
    /// <param name="decryptString">待解密的字符串</param>
    /// <param name="decryptKey">解密密钥,要求为8位,和加密密钥相同</param>
    /// <returns>解密成功返回解密后的字符串，失败返源串</returns>
    public static string DecryptDES(string decryptString, string decryptKey)
    {
        try
        {
            byte[] rgbKey = Encoding.UTF8.GetBytes(decryptKey);
            byte[] rgbIV = Keys;
            byte[] inputByteArray = Convert.FromBase64String(decryptString);
            DESCryptoServiceProvider DCSP = new DESCryptoServiceProvider();
            MemoryStream mStream = new MemoryStream();
            CryptoStream cStream = new CryptoStream(mStream, DCSP.CreateDecryptor(rgbKey, rgbIV), CryptoStreamMode.Write);
            cStream.Write(inputByteArray, 0, inputByteArray.Length);
            cStream.FlushFinalBlock();
            return Encoding.UTF8.GetString(mStream.ToArray());
        }
        catch
        {
            return decryptString;
        }

    }