createdatasamples.dtsx

来自「< SQL Server2005程序设计>」· DTSX 代码 · 共 339 行 · 第 1/5 页

<property id="9" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">0</property>
<property id="15" name="ParameterMapping" dataType="System.String" state="default" isArray="false" description="The mappings between the parameters in the SQL command and variables." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property></properties>
<connections>
<connection id="10" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{1DD200C3-AECF-450A-B7EA-075BCA9C9A08}"/></connections>
<outputs>
<output id="11" name="OLE DB Source Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
<outputColumn id="32" name="CustomerKey" description="" lineageId="32" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="31"/>
<outputColumn id="35" name="MaritalStatus" description="" lineageId="35" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="34"/>
<outputColumn id="38" name="Gender" description="" lineageId="38" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="37"/>
<outputColumn id="41" name="YearlyIncome" description="" lineageId="41" precision="0" scale="0" length="0" dataType="cy" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="40"/>
<outputColumn id="44" name="IncomeGroup" description="" lineageId="44" precision="0" scale="0" length="8" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="43"/>
<outputColumn id="47" name="TotalChildren" description="" lineageId="47" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="46"/>
<outputColumn id="50" name="HasKids" description="" lineageId="50" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="49"/>
<outputColumn id="53" name="NumberChildrenAtHome" description="" lineageId="53" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="52"/>
<outputColumn id="56" name="HasKidsAtHome" description="" lineageId="56" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="55"/>
<outputColumn id="59" name="EnglishEducation" description="" lineageId="59" precision="0" scale="0" length="40" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="58"/>
<outputColumn id="62" name="EnglishOccupation" description="" lineageId="62" precision="0" scale="0" length="100" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="61"/>
<outputColumn id="65" name="IsHomeOwner" description="" lineageId="65" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="64"/>
<outputColumn id="68" name="NumberCarsOwned" description="" lineageId="68" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="67"/>
<outputColumn id="71" name="IsCarOwner" description="" lineageId="71" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="70"/>
<outputColumn id="74" name="NumberCarsOwnedGroup" description="" lineageId="74" precision="0" scale="0" length="7" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="73"/>
<outputColumn id="77" name="AddressLine1" description="" lineageId="77" precision="0" scale="0" length="120" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="76"/>
<outputColumn id="80" name="AddressLine2" description="" lineageId="80" precision="0" scale="0" length="120" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="79"/>
<outputColumn id="83" name="Phone" description="" lineageId="83" precision="0" scale="0" length="20" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="82"/>
<outputColumn id="86" name="DateFirstPurchase" description="" lineageId="86" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="85"/>
<outputColumn id="89" name="CommuteDistance" description="" lineageId="89" precision="0" scale="0" length="15" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="88"/>
<outputColumn id="92" name="Region" description="" lineageId="92" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="91"/>
<outputColumn id="95" name="Age" description="" lineageId="95" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="94"/>
<outputColumn id="98" name="AgeGroup" description="" lineageId="98" precision="0" scale="0" length="9" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="97"/>
<outputColumn id="101" name="NumOrders" description="" lineageId="101" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="100"/>
<outputColumn id="104" name="IsOneTimeCustomer" description="" lineageId="104" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="103"/>
<outputColumn id="107" name="Recency" description="" lineageId="107" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="106"/>
<outputColumn id="110" name="PurchasedWithin12Months" description="" lineageId="110" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="109"/>
<outputColumn id="113" name="RecencyGroup" description="" lineageId="113" precision="0" scale="0" length="19" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="112"/>
<outputColumn id="116" name="NumberOfProducts" description="" lineageId="116" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="115"/>
<outputColumn id="119" name="NumProdGroup" description="" lineageId="119" precision="0" scale="0" length="2" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="118"/>
<outputColumn id="122" name="Tenure" description="" lineageId="122" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="121"/>
<outputColumn id="125" name="IsNewCustomer" description="" lineageId="125" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="124"/>
<outputColumn id="128" name="Revenue" description="" lineageId="128" precision="0" scale="0" length="0" dataType="cy" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="127"/>
<outputColumn id="131" name="Profit" description="" lineageId="131" precision="0" scale="0" length="0" dataType="cy" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="130"/>
<outputColumn id="134" name="ProfitPerOrder" description="" lineageId="134" precision="30" scale="17" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="133"/>
<outputColumn id="137" name="ProfitPerMonth" description="" lineageId="137" precision="30" scale="17" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="136"/>
<outputColumn id="140" name="ProfitMargin" description="" lineageId="140" precision="38" scale="21" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="139"/>
<outputColumn id="143" name="RatioRevenueToTenure" description="" lineageId="143" precision="30" scale="17" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="142"/>
<outputColumn id="146" name="RatioNumProdToTenure" description="" lineageId="146" precision="30" scale="17" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="145"/>
<outputColumn id="149" name="RatioProfitToTenure" description="" lineageId="149" precision="30" scale="17" length="0" dataType="numeric" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="148"/></outputColumns><externalMetadataColumns isUsed="True">
<externalMetadataColumn id="31" name="CustomerKey" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>
<externalMetadataColumn id="34" name="MaritalStatus" description="" precision="0" scale="0" length="1" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="37" name="Gender" description="" precision="0" scale="0" length="1" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="40" name="YearlyIncome" description="" precision="0" scale="0" length="0" dataType="cy" codePage="0"/>
<externalMetadataColumn id="43" name="IncomeGroup" description="" precision="0" scale="0" length="8" dataType="str" codePage="1252"/>
<externalMetadataColumn id="46" name="TotalChildren" description="" precision="0" scale="0" length="0" dataType="ui1" codePage="0"/>
<externalMetadataColumn id="49" name="HasKids" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
<externalMetadataColumn id="52" name="NumberChildrenAtHome" description="" precision="0" scale="0" length="0" dataType="ui1" codePage="0"/>
<externalMetadataColumn id="55" name="HasKidsAtHome" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
<externalMetadataColumn id="58" name="EnglishEducation" description="" precision="0" scale="0" length="40" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="61" name="EnglishOccupation" description="" precision="0" scale="0" length="100" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="64" name="IsHomeOwner" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
<externalMetadataColumn id="67" name="NumberCarsOwned" description="" precision="0" scale="0" length="0" dataType="ui1" codePage="0"/>
<externalMetadataColumn id="70" name="IsCarOwner" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/>
<externalMetadataColumn id="73" name="NumberCarsOwnedGroup" description="" precision="0" scale="0" length="7" dataType="str" codePage="1252"/>
<externalMetadataColumn id="76" name="AddressLine1" description="" precision="0" scale="0" length="120" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="79" name="AddressLine2" description="" precision="0" scale="0" length="120" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="82" name="Phone" description="" precision="0" scale="0" length="20" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="85" name="DateFirstPurchase" description="" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0"/>
<externalMetadataColumn id="88" name="CommuteDistance" description="" precision="0" scale="0" length="15" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="91" name="Region" description="" precision="0" scale="0" length="50" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="94" name="Age" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>