public IDTSParameterBinding Modify_ExecSQL_AddParameterBinding(
Executable ex,
string BingingVariableName,
OleDBDataTypes BingingDataType
)
{
TaskHost SQLth = (TaskHost)ex;
ExecuteSQLTask task = SQLth.InnerObject as ExecuteSQLTask;
int i = 0;
foreach (IDTSParameterBinding z in task.ParameterBindings)
{
i++;
}
task.ParameterBindings.Add();
IDTSParameterBinding pb = task.ParameterBindings.GetBinding(i);
pb.DtsVariableName = BingingVariableName;
pb.ParameterDirection = ParameterDirections.Input;
pb.DataType = (int)BingingDataType;
pb.ParameterName = i;
pb.ParameterSize = -1;
return(pb);
}
/// <summary>
/// Extension method to easily add parameters bindings with direction to ExecSQLTask
/// </summary>
/// <param name="binds"></param>
/// <param name="parameterName"></param>
/// <param name="dtsVariableName"></param>
/// <param name="dataType"></param>
public static void Add(this IDTSParameterBindings binds, ParameterDirections direction, string parameterName, string dtsVariableName, OleDBDataTypes dataType)
{
IDTSParameterBinding x = binds.Add();
x.ParameterName = parameterName;
x.DtsVariableName = dtsVariableName;
x.ParameterDirection = direction;
x.DataType = (int)dataType;
}
