private void BindParameter(DTS.Variable variable, DTSTasks.ExecuteSQLTask.ParameterDirections direction, string parameterName, int dataType, int size)
{
DTSTasks.ExecuteSQLTask.IDTSParameterBinding binding = SSISTask.ParameterBindings.Add();
binding.DtsVariableName = variable.QualifiedName;
binding.ParameterDirection = direction;
binding.ParameterName = parameterName;
binding.ParameterSize = size;
binding.DataType = dataType;
}
private void BindParameter(string variableName, DTSTasks.ExecuteSQLTask.ParameterDirections direction, string parameterName, int dataType, int size)
{
DTSTasks.ExecuteSQLTask.IDTSParameterBinding binding = ExecuteSqlTask.ParameterBindings.Add();
binding.ParameterDirection = direction;
binding.ParameterName = parameterName;
binding.ParameterSize = size;
binding.DataType = dataType;
if (DtsTaskHost.Variables.Contains(variableName))
{
binding.DtsVariableName = DtsTaskHost.Variables[variableName].QualifiedName;
}
else
{
MessageEngine.Trace(AstNamedNode, Severity.Error, "V0110", "Task {0}: Could not Bind Parameter {1}: Variable {2} does not exist", Name, parameterName, variableName);
}
}