private void BindResult(string resultName, string variableName)
{
DTSTasks.ExecuteSQLTask.IDTSResultBindings resultBindings = SSISTask.ResultSetBindings;
DTSTasks.ExecuteSQLTask.IDTSResultBinding result = resultBindings.Add();
result.ResultName = resultName;
if (_sqlTask.Variables.Contains(variableName))
{
result.DtsVariableName = _sqlTask.Variables[variableName].QualifiedName;
}
else
{
MessageEngine.Global.Trace(Severity.Error, "Task {0}: Could not Bind ResultSet: Variable {1} does not exist", this.Name, variableName);
}
}
public void BindResult(string resultName, string variableName)
{
DTSTasks.ExecuteSQLTask.IDTSResultBindings resultBindings = this.ExecuteSQLTask.ResultSetBindings;
DTSTasks.ExecuteSQLTask.IDTSResultBinding result = resultBindings.Add();
result.ResultName = resultName;
if (VulcanPackage.DTSPackage.Variables.Contains(variableName))
{
result.DtsVariableName = VulcanPackage.DTSPackage.Variables[variableName].QualifiedName;
}
else
{
Message.Trace(Severity.Error, "Task {0}: Could not Bind ResultSet: Variable {1} does not exist", this.Name, variableName);
}
}
private void BindResult(string resultName, string variableName)
{
DTSTasks.ExecuteSQLTask.IDTSResultBindings resultBindings = ExecuteSqlTask.ResultSetBindings;
DTSTasks.ExecuteSQLTask.IDTSResultBinding result = resultBindings.Add();
result.ResultName = resultName;
if (DtsTaskHost.Variables.Contains(variableName))
{
result.DtsVariableName = DtsTaskHost.Variables[variableName].QualifiedName;
}
else
{
MessageEngine.Trace(AstNamedNode, Severity.Error, "V0109", "Task {0}: Could not Bind ResultSet: Parameter {1}, Variable {2} does not exist", Name, resultName, variableName);
}
}