2.7.1.8.1.1.1 Exec80PackageTaskType

  • Article

The Exec80PackageTaskType complex type holds parameters, properties, and settings for an Execute DTS 2000 Package Task.

The following is the XSD for the Exec80PackageTaskType complex type.

   <xs:complexType name="Exec80PackageTaskType">
     <xs:sequence>
       <xs:element name="DTS2000Package" type="xs:base64Binary"
                   minOccurs="0" form="unqualified"/>
     </xs:sequence>
     <xs:attribute name="Location" 
                   type="Exec80PackageTask:Exec80PackageTaskLocationEnum"/>
     <xs:attribute name="PackageName" type="xs:string"/>
     <xs:attribute name="PackageID" type="xs:string"/>
     <xs:attribute name="PackageVersionGUID" type="xs:string"/>
     <xs:attribute name="SQLServer" type="xs:string"/>
     <xs:attribute name="SQLUsername" type="xs:string"/>
     <xs:attribute name="WindowsAuthentication">
       <xs:simpleType>
         <xs:restriction base="xs:string">
           <xs:enumeration value="True"/>
           <xs:enumeration value="False"/>
         </xs:restriction>
       </xs:simpleType>
     </xs:attribute>
     <xs:attribute name="Filename" type="xs:string"/>
     <xs:attribute name="InnerGlobalVariables" type="xs:string"/>
     <xs:attribute name="OuterGlobalVariables" type="xs:string"/>
   </xs:complexType>

The following table specifies the elements of the Exec80PackageTaskType complex type.

Element

Type definition

Description

DTS2000Package

xs:base64Binary

This element stores the content of the DTS 2000 package in binary format. If this element is present, the DTS 2000 package is not retrieved from an external location.

The following table specifies additional information for the attributes of the Exec80PackageTaskType complex type.

Attribute

Description

Location

This enumeration value specifies the storage location for the DTS 2000 package file.

PackageName

This string specifies the name of the DTS 2000 package that is executed.

PackageID

This GUID value specifies the ID of the DTS 2000 package that is executed.

PackageVersionGUID

A GUID value that is unique to every version of the DTS 2000 package.<83>

SQLServer

This string value contains the name of the server instance.<84>

SQLUsername

This string value contains the database username.<85>

WindowsAuthentication

An enumeration value that specifies whether Windows Authentication is used.

"True" specifies that Windows Authentication is used.

"False" specifies that Windows Authentication is not used.

Filename

This string value specifies the name of the file. This value is used only if the Location attribute has a value of "StorageFile".

InnerGlobalVariables

A string value that contains a collection of variables that are the inner variables for the task.

OuterGlobalVariables

A string value that contains a collection of variables that are the outer variables for the task.