DataTable dtTableDataDefinition = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.Fill(dtTableDataDefinition, Dts.Variables["User::dsDataDefinitionConfig"].Value);
foreach (DataRow
row in dtTableDataDefinition.Rows)
{
if (Dts.Variables.Contains(row["DataDefinitionKey"]))
{
Variables vars=null;
Dts.VariableDispenser.LockOneForWrite(row["DataDefinitionKey"].ToString(),
ref vars);
vars[row["DataDefinitionKey"].ToString()].Value
= row["DataDefinitionKeyvalue"].ToString();
vars.Unlock();
}
}
Dts.TaskResult
= (int)ScriptResults.Success;
No comments:
Post a Comment