Friday, August 16, 2013

Populate variables with dynamic values



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