WebServiceTask.OutputType Property

Article
12/03/2008

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

Namespace: Microsoft.SqlServer.Dts.Tasks.WebServiceTask
Assembly: Microsoft.SqlServer.WebServiceTask (in microsoft.sqlserver.webservicetask.dll)

Syntax

'Declaration
Public Property OutputType As DTSOutputType

public DTSOutputType OutputType { get; set; }

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

/** @property */
public DTSOutputType get_OutputType ()

/** @property */
public void set_OutputType (DTSOutputType value)

public function get OutputType () : DTSOutputType

public function set OutputType (value : DTSOutputType)

Property Value

A value from the DTSOutputType that indicates the location to store the results of the Web method.

Example

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via