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); } }