Beispiel #1
0
        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);
            }
        }
Beispiel #2
0
        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);
            }
        }
Beispiel #3
0
        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);
            }
        }