aa.dtsconfig

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DTSCONFIG 代码 · 共 3 行

<?xml version="1.0"?><DTSConfiguration><DTSConfigurationHeading><DTSConfigurationFileInfo GeneratedBy="" GeneratedFromPackageName="alldemo" GeneratedFromPackageID="{62E2E654-1C34-4FA0-87C2-640075A7DA4A}" GeneratedDate="2007-2-7 19:49:03"/></DTSConfigurationHeading><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>Data Source=(local);Initial Catalog=AdventureWorks;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[Description]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[InitialCatalog]" ValueType="String"><ConfiguredValue>AdventureWorks</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[Name]" ValueType="String"><ConfiguredValue>(local).AdventureWorks</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[Password]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[ProtectionLevel]" ValueType="Int32"><ConfiguredValue>1</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[RetainSameConnection]" ValueType="Boolean"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[ServerName]" ValueType="String"><ConfiguredValue>(local)</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[(local).AdventureWorks].Properties[UserName]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CreateTableSQL].Properties[ConnectionString]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CreateTableSQL].Properties[Description]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CreateTableSQL].Properties[FileUsageType]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CreateTableSQL].Properties[Name]" ValueType="String"><ConfiguredValue>CreateTableSQL</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CreateTableSQL].Properties[ProtectionLevel]" ValueType="Int32"><ConfiguredValue>1</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[CodePage]" ValueType="Int32"><ConfiguredValue>1252</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[ColumnNamesInFirstDataRow]" ValueType="Boolean"><ConfiguredValue>-1</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteSQLStatementsInLoop Sample\Data Files\Customers.txt</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[DataRowsToSkip]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[Description]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[FileUsageType]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[Format]" ValueType="String"><ConfiguredValue>Delimited</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[HeaderRowDelimiter]" ValueType="String"><ConfiguredValue>
</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[HeaderRowsToSkip]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[LocaleID]" ValueType="Int32"><ConfiguredValue>1033</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[Name]" ValueType="String"><ConfiguredValue>Customers</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[ProtectionLevel]" ValueType="Int32"><ConfiguredValue>1</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[RowDelimiter]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[TextQualifier]" ValueType="String"><ConfiguredValue>&lt;none&gt;</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[Customers].Properties[Unicode]" ValueType="Boolean"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[CodePage]" ValueType="Int32"><ConfiguredValue>1252</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[ColumnNamesInFirstDataRow]" ValueType="Boolean"><ConfiguredValue>-1</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteSQLStatementsInLoop Sample\Data Files\CustomersWithInvalidTerrritoryID.txt</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[DataRowsToSkip]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[Description]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[FileUsageType]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[Format]" ValueType="String"><ConfiguredValue>Delimited</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[HeaderRowDelimiter]" ValueType="String"><ConfiguredValue>
</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[HeaderRowsToSkip]" ValueType="Int32"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[LocaleID]" ValueType="Int32"><ConfiguredValue>1033</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[Name]" ValueType="String"><ConfiguredValue>CustomersWithInvalidTerrritoryID</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[ProtectionLevel]" ValueType="Int32"><ConfiguredValue>1</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[RowDelimiter]" ValueType="String"><ConfiguredValue></ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[TextQualifier]" ValueType="String"><ConfiguredValue>&lt;none&gt;</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[CustomersWithInvalidTerrritoryID].Properties[Unicode]" ValueType="Boolean"><ConfiguredValue>0</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package\Foreach 寰