从脚本组件+ SSIS执行SQL
我试图从脚本组件执行sql,但在尝试建立SQL连接时出错。我在下面的脚本组件代码PreExecute下()从脚本组件+ SSIS执行SQL
base.PreExecute();
variables = null;
VariableDispenser.LockForWrite("User::TableName");
VariableDispenser.LockForWrite("User::SqlConnectionString");
VariableDispenser.GetVariables(out variables);
tableName = variables[0].Value.ToString();
sqlConnection = variables[1].Value.ToString();
dt = new DataTable();
//sqlConnection = Data Source=LOCALHOST;Initial Catalog=MergeTestDestination;Integrated Security=True;
using (SqlConnection cnn = new SqlConnection(sqlConnection))
{
try
{
cnn.Open();
MessageBox.Show("We are connected.....");
cnn.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
错误:
在System.Data.Common.DbConnectionOptions.GetKeyValuePair(字符串的connectionString,的Int32 currentPosition,StringBuilder的缓冲,布尔useOdbcRules,字符串&键名,字符串& keyvalue) at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable,String connectionString,Boolean buildChain,Hashtable同义词,Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString,Hashtable的同义词,布尔useOdbcRules) 在System.Data.SqlClient.SqlConnectionString..ctor(字符串的connectionString) 在System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(字符串的connectionString,DbConnectionOptions先前) 在System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(字符串的connectionString,DbConnectionPoolGroupOptions poolOptions,DbConnectionOptions & userConnectionOptions) 在System.Data.SqlClient.SqlConnection.ConnectionString_Set(字符串值) 在System.Data.SqlClient.SqlConnection.set_ConnectionString(字符串值) 在System.Data.SqlClient.SqlConnection..ctor(字符串connectionString) at ScriptMain.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()
我做错了什么?任何帮助?
感谢
连接构造 Debug.Assert的(string.IsNullOrEmpty(SqlConnection的)!)之前,将下面的代码;