Home
  •  

MSSQL: Generic Template Seed Test Connectivity task Write Action

Microsoft.SQLServer.Core.Task.TemplateSeed.TestConnection.WA (WriteActionModuleType)

Template Seed Test Connectivity task Write Action

Element properties:

TypeWriteActionModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
InputTypeSystem.BaseData
OutputTypeSystem.PropertyBagData

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
SqlTimeoutSecondsint$Config/SqlTimeoutSeconds$Timeout for database connection (seconds)The workflow will fail and register an event, if it cannot access the database during the specified period.
TimeoutSecondsint$Config/TimeoutSeconds$Timeout (seconds)Specifies the time the workflow is allowed to run before being closed and marked as failed.
ConnectionStringstring$Config/ConnectionString$

Source Code:

<WriteActionModuleType ID="Microsoft.SQLServer.Core.Task.TemplateSeed.TestConnection.WA" Accessibility="Internal" Batching="false">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConnectionString" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Login" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Password" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlTimeoutSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Publisher" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ManagementGroupName" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="SqlTimeoutSeconds" ParameterType="int" Selector="$Config/SqlTimeoutSeconds$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

    <OverrideableParameter ID="ConnectionString" ParameterType="string" Selector="$Config/ConnectionString$"/>

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Managed>

      <Assembly>Microsoft.SQLServer.Core.Module.Helper.Assembly</Assembly>

      <Type>Microsoft.SQLServer.Core.Module.Helper.Tasks.TestConnection</Type>

    </Managed>

  </ModuleImplementation>

  <OutputType>System!System.PropertyBagData</OutputType>

  <InputType>System!System.BaseData</InputType>

</WriteActionModuleType>