public ExecuteSqlParameter(string name, string variableName, ParameterDirections direction, OleDbType oleDBType, int length)
{
Name = name;
VariableName = variableName;
Direction = direction;
OleDBType = oleDBType;
Length = length;
}
/// <summary>
/// ctor accepts an ISExecuteSqlTask and various Paramater Binding Properties
/// If a ParameterBinding with the passed name exists, then that is used; otherwise a new Parameter Binding is created
/// </summary>
/// <param name="sqlTask"></param>
/// <param name="dataType"></param>
/// <param name="dtsVariableName"></param>
/// <param name="paramDirection"></param>
/// <param name="paramName"></param>
/// <param name="paramSize"></param>
public ISParameterBinding(ISExecuteSqlTask sqlTask, int dataType, string dtsVariableName, ParameterDirections paramDirection, object paramName, int paramSize)
{
bool paramExists = false;
IEnumerator parameters = sqlTask.ParameterBindings_m.GetEnumerator();
while (parameters.MoveNext())
{
IDTSParameterBinding param = (parameters.Current as IDTSParameterBinding);
if (param.ParameterName.ToString() == paramName.ToString())
{
paramExists = true;
ParameterBinding = param;
}
}
if (paramExists == false)
{
ParameterBinding = sqlTask.ParameterBindings_m.Add();
ParameterName = paramName;
}
DataType = dataType;
DtsVariableName = dtsVariableName;
ParameterDirection = paramDirection;
ParameterSize = paramSize;
}
public ISParameterBinding AddParameterBinding(int dataType, string dtsVariableName, ParameterDirections paramDirection, object paramName, int paramSize)
{
return(new ISParameterBinding(this, dataType, dtsVariableName, paramDirection, paramName, paramSize));
}
