Exemplos de Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterDirections em C# (CSharp)

Exemplo n.º 1

Arquivo: SQLTask.cs Projeto: mosamy/vulcan

 public void BindParameter(DTS.Variable variable, Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterDirections direction, string parameterName, int dataType, int size)
 {
     DTSTasks.ExecuteSQLTask.IDTSParameterBinding binding = ExecuteSQLTask.ParameterBindings.Add();
     binding.DtsVariableName    = variable.QualifiedName;
     binding.ParameterDirection = direction;
     binding.ParameterName      = parameterName;
     binding.ParameterSize      = size;
     binding.DataType           = dataType;
 }

Exemplo n.º 2

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

Exemplo n.º 3

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

Exemplo n.º 4

Arquivo: SQLTask.cs Projeto: mosamy/vulcan

 public void BindParameter(DTS.Variable variable, Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterDirections direction, int dataType, int size)
 {
     BindParameter(variable, direction, _parameterIndex.ToString(), dataType, size);
     _parameterIndex++;
 }

Exemplo n.º 5

Arquivo: SQLTask.cs Projeto: mosamy/vulcan

 public void BindParameter(DTS.Variable variable, Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterDirections direction, int dataType)
 {
     BindParameter(variable, direction, dataType, -1);
 }