2.7.1.19 TransferJobsTaskDataObjectDataType

  • Article

The TransferJobsTaskDataObjectDataType complex type is used to specify parameters, properties, and settings that are specific to the Transfer Database Task. 

The following is the XSD for the TransferJobsTaskDataObjectDataType complex type.

   <xs:complexType name="TransferJobsTaskDataObjectDataType">
     <xs:sequence/>
     <xs:attribute name="TransferAllJobs" type="xs:boolean" 
                   form="unqualified"/>
     <xs:attribute name="JobsList" type="xs:string" 
                   form="unqualified"/>
     <xs:attribute name="IfObjectExists" type="DTS:IfObjectExistsEnum" 
                   form="unqualified"/>
     <xs:attribute name="EnableJobsAtDestination" type="xs:boolean" 
                   form="unqualified"/>
     <xs:attribute name="SourceConnection" type="xs:string" 
                   form="unqualified"/>
     <xs:attribute name="DestinationConnection" type="xs:string" 
                   form="unqualified"/>
   </xs:complexType>

The TransferJobsTaskDataObjectDataType complex type MUST NOT contain any elements or values.

The following table specifies the attributes of the TransferJobsTaskDataObjectDataType complex type.

Attribute

Description

TransferAllJobs

A Boolean value that specifies whether to transfer all jobs or only the specified jobs.

TRUE specifies that all jobs are transferred.

FALSE specifies that only the specified jobs are transferred.

JobsList

A string value that specifies a list of jobs that are transferred.

IfObjectExists

An enumeration value that specifies what action is taken if a job of the same name already exists at the destination.

EnableJobsAtDestination

A Boolean value that specifies whether to enable jobs that are created at the destination.

TRUE specifies that jobs that are created at the destination MUST be enabled.

FALSE specifies that jobs that are created at the destination MUST NOT be enabled.

SourceConnection

A string value that specifies a reference to a connection manager by its DTSID property value or by its ObjectName property value.

DestinationConnection

A string value that specifies a reference to a connection manager by its DTSID property value or by its ObjectName property value.