Partager via

  • Article

Propriété OutputType

Gets or sets a value that indicates the storage location of the result of the Web method invocation.

Espace de noms :  Microsoft.SqlServer.Dts.Tasks.WebServiceTask
Assembly :  Microsoft.SqlServer.WebServiceTask (en Microsoft.SqlServer.WebServiceTask.dll)

Syntaxe

'Déclaration
Public Property OutputType As DTSOutputType
    Get
    Set
'Utilisation
Dim instance As WebServiceTask
Dim value As DTSOutputType

value = instance.OutputType

instance.OutputType = value

public DTSOutputType OutputType { get; set; }

public:
property DTSOutputType OutputType {
    DTSOutputType get ();
    void set (DTSOutputType value);
}

member OutputType : DTSOutputType with get, set

function get OutputType () : DTSOutputType
function set OutputType (value : DTSOutputType)

Valeur de propriété

Type : Microsoft.SqlServer.Dts.Tasks.WebServiceTask. . :: . .DTSOutputType
A value from the DTSOutputType that indicates the location to store the results of the Web method.

Exemples

The following code example creates a WebServiceTask, shows the default settings of the properties, including the OutputType, using the TaskHost. It then sets two fields to show how to set field values.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.WebServiceTask;

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Package pkg = new Package();
            Executable exec1 = pkg.Executables.Add("STOCK:WebServiceTask");
            TaskHost th = exec1 as TaskHost;

            // List the default values of the Web Service task
            // using the Properties collection of the TaskHost.
            Console.WriteLine("Connection        {0}", th.Properties["Connection"].GetValue(th));
            Console.WriteLine("DebugMode         {0}", th.Properties["DebugMode"].GetValue(th));
            Console.WriteLine("OutputLocation    {0}", th.Properties["OutputLocation"].GetValue(th));
            Console.WriteLine("OutputType        {0}", th.Properties["OutputType"].GetValue(th));
            Console.WriteLine("OverwriteWsdlFile {0}", th.Properties["OverwriteWsdlFile"].GetValue(th));
            Console.WriteLine("ServiceName       {0}", th.Properties["ServiceName"].GetValue(th));
            Console.WriteLine("SuspendRequired   {0}", th.Properties["SuspendRequired"].GetValue(th));
            Console.WriteLine("WebMethodInfo     {0}", th.Properties["WebMethodInfo"].GetValue(th));
            Console.WriteLine("WsdlFile          {0}", th.Properties["WsdlFile"].GetValue(th));

            Console.WriteLine("--------------------------");
            // Show how to set a property using the TaskHost Properties.
            th.Properties["OutputType"].SetValue(th, DTSOutputType.File);
            th.Properties["OverwriteWsdlFile"].SetValue(th, true);

            Console.WriteLine("New value of OutputType and OverwriteWsdlFile: {0}, {1}", th.Properties["OutputType"].GetValue(th), th.Properties["OverwriteWsdlFile"].GetValue(th));
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.WebServiceTask
 
Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim pkg As Package =  New Package() 
            Dim exec1 As Executable =  pkg.Executables.Add("STOCK:WebServiceTask") 
            Dim th As TaskHost =  exec1 as TaskHost 
 
            ' List the default values of the Web Service task
            ' using the Properties collection of the TaskHost.
            Console.WriteLine("Connection        {0}", th.Properties("Connection").GetValue(th))
            Console.WriteLine("DebugMode         {0}", th.Properties("DebugMode").GetValue(th))
            Console.WriteLine("OutputLocation    {0}", th.Properties("OutputLocation").GetValue(th))
            Console.WriteLine("OutputType        {0}", th.Properties("OutputType").GetValue(th))
            Console.WriteLine("OverwriteWsdlFile {0}", th.Properties("OverwriteWsdlFile").GetValue(th))
            Console.WriteLine("ServiceName       {0}", th.Properties("ServiceName").GetValue(th))
            Console.WriteLine("SuspendRequired   {0}", th.Properties("SuspendRequired").GetValue(th))
            Console.WriteLine("WebMethodInfo     {0}", th.Properties("WebMethodInfo").GetValue(th))
            Console.WriteLine("WsdlFile          {0}", th.Properties("WsdlFile").GetValue(th))
 
            Console.WriteLine("--------------------------")
            ' Show how to set a property using the TaskHost Properties.
            th.Properties("OutputType").SetValue(th, DTSOutputType.File)
            th.Properties("OverwriteWsdlFile").SetValue(th, True)
 
            Console.WriteLine("New value of OutputType and OverwriteWsdlFile: {0}, {1}", th.Properties("OutputType").GetValue(th), th.Properties("OverwriteWsdlFile").GetValue(th))
        End Sub
    End Class
End Namespace

Sample Output:

Connection

DebugMode False

OutputLocation

OutputType 0

OverwriteWsdlFile False

ServiceName

SuspendRequired False

WebMethodInfo

WsdlFile

--------------------------

New value of OutputType and OverwriteWsdlFile: 0, True