2.4.4.1.2.1.1 ConnectionManagerConnectionManagerAttributeGroup

The ConnectionManagerConnectionManagerAttributeGroup attribute group contains the attributes for the ConnectionManagerObjectDataConnectionManagerType type.

The following is the XSD for the ConnectionManagerConnectionManagerAttributeGroup attribute group.

  <xs:attributeGroup name="ConnectionManagerConnectionManagerAttributeGroup">
    <xs:attribute name="Retain" type="DTS:BooleanStringCap" default="False"
                  use="optional" form="qualified"/>
    <xs:attribute name="ConnectionString" type="xs:string" use="required"
                  form="qualified"/>
    <xs:attribute name="FileUsageType" type="DTS:FileUsageTypeEnum"
                  default="0" use="optional" form="qualified"/>
    <xs:attribute name="Format" type="DTS:FormatEnum" use="optional"
                  form="qualified"/>
    <xs:attribute name="LocaleID" type="xs:int" use="optional"
                  form="qualified"/>
    <xs:attribute name="Unicode" type="DTS:BooleanStringCap" default="False"
                  use="optional" form="qualified"/>
    <xs:attribute name="HeaderRowsToSkip" type="xs:int" default="0"
                  use="optional" form="qualified"/>
    <xs:attribute name="HeaderRowDelimiter" type="xs:string" use="optional"
                  form="qualified"/>
    <xs:attribute name="ColumnNamesInFirstDataRow" default="False"
                  type="DTS:BooleanStringCap" use="optional" form="qualified"/>
    <xs:attribute name="RowDelimiter" type="xs:string" use="optional"
                  form="qualified"/>
    <xs:attribute name="DataRowsToSkip" type="xs:int" default="0"
                  use="optional" form="qualified"/>
    <xs:attribute name="TextQualifier" type="xs:string" use="optional"
                  form="qualified"/>
    <xs:attribute name="CodePage" type="xs:int" use="optional"
                  form="qualified"/>
    <xs:attribute name="ServerName" type="xs:string" use="optional"
                  form="qualified"/>
    <xs:attribute name="UseFile" type="DTS:BooleanStringCap"
                  default="False" use="optional" form="qualified"/>
    <xs:attribute name="UseEncryption" type="DTS:BooleanStringCap"
                  default="False" use="optional" form="qualified"/>
    <xs:attribute name="RetainData" type="DTS:BooleanStringCap"
                  default="True" use="optional" form="qualified"/>
  </xs:attributeGroup>

The following table specifies the attributes for the ConnectionManagerConnectionManagerAttributeGroup attribute group.

Attribute	Description
Retain	A value of type DTS:BooleanStringCap that specifies whether the same connection is retained between successive data accesses. False specifies that the connection is not retained between successive data accesses. True specifies that the connection is retained between successive data accesses.
ConnectionString	A string value that is handed to the data source upon connection. The contents of the string vary with the source type.
FileUsageType	An enumeration value that specifies how the file connection is used.
Format	An enumeration value that specifies the type of formatting in the records and fields of a file.
LocaleID	An integer value that specifies the language code identifier (LCID) for the language for this executable.<7>
Unicode	A value of type DTS:BooleanStringCap that specifies an indicator for whether the data source contains Unicode characters. False indicates that the data obtained from the connection is not Unicode. True specifies that the data obtained from the connection is Unicode.
HeaderRowsToSkip	An integer value that represents the number of header rows to skip in the data source.
HeaderRowDelimiter	A string value that specifies a hexadecimal-encoded value in ASCII [US-ASCII] for the character or character string that is the delimiter for the header row. Each such character MUST be prepended and post-pended with an underscore (_) character. For example, the string "_x000D__x000A_" specifies the sequence of characters: a carriage return character followed by a line feed character.
ColumnNamesInFirstDataRow	An enumeration value that specifies whether the first row contains column names. False specifies that the first row does not contain column names. True specifies that the first data row contains column names.
RowDelimiter	A string value that specifies the row delimiter.<8>
DataRowsToSkip	An integer value that specifies the number of data rows to skip.
TextQualifier	A string value that specifies a character that is used to indicate text values.
CodePage	Specifies that the element value is the numeric value of the ANSI code page that is used for strings.<9>
ServerName	A string value that specifies the name of the server for the connection.
UseFile	A value of type DTS:BooleanStringCap that specifies whether the cache is backed by a cache file on disk or stored only in memory. True specifies that a file is used. False specifies that the cache is stored only in memory and erased when the package terminates.
UseEncryption	A value of type DTS:BooleanStringCap that specifies whether to use encryption for data access. True specifies to use encryption for data access. False specifies not to use encryption for data access.
RetainData	A value of type DTS:BooleanStringCap that specifies whether data is retained.<10> True specifies that data is retained. False specifies that data is not retained.