create dm data sets.dtsx

数据仓库开发的很好的一个例子

<components>
<component id="397" name="Percentage Sampling" componentClassID="{481EA6F5-D9F0-4AF4-AA73-466D0390826B}" description="Percentage Sampling Transformation" localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Percentage Sampling;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
<properties>
<property id="398" name="SamplingValue" dataType="System.Int32" state="default" isArray="false" description="Specifies the percentage size of the sample." typeConverter="" UITypeEditor="" containsID="false" expressionType="Notify">10</property>
<property id="399" name="SamplingSeed" dataType="System.Int32" state="default" isArray="false" description="Specifies the seed for the random number generator." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
<inputs>
<input id="400" name="Percentage Sampling Input 1" description="" hasSideEffects="false" dangling="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><externalMetadataColumns isUsed="False"/></input>
</inputs>
<outputs>
<output id="401" name="Test Data Set" description="" exclusionGroup="1" synchronousInputId="400" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><properties>
<property id="402" name="Selected" dataType="System.Boolean" state="default" isArray="false" description="Output for rows in the sample" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</property></properties><externalMetadataColumns isUsed="False"/></output>
<output id="403" name="Training Data Set" description="" exclusionGroup="1" synchronousInputId="400" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><properties>
<property id="404" name="Selected" dataType="System.Boolean" state="default" isArray="false" description="Output for rows in the sample" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties><externalMetadataColumns isUsed="False"/></output>
</outputs>
</component>
<component id="162" name="Row Sampling" componentClassID="{19FBD9D1-7707-49F8-8EB2-BD7C6DA183C2}" description="Row Sampling Transformation" localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Row Sampling;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
<properties>
<property id="163" name="SamplingValue" dataType="System.Int32" state="default" isArray="false" description="Specifies the number of rows in the sample." typeConverter="" UITypeEditor="" containsID="false" expressionType="Notify">18000</property>
<property id="164" name="SamplingSeed" dataType="System.Int32" state="default" isArray="false" description="Specifies the seed for the random number generator." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
<inputs>
<input id="165" name="Row Sampling Input 1" description="" hasSideEffects="false" dangling="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><inputColumns>
<inputColumn id="179" name="" description="" lineageId="100" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="182" name="" description="" lineageId="103" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="185" name="" description="" lineageId="106" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="188" name="" description="" lineageId="109" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="191" name="" description="" lineageId="112" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="194" name="" description="" lineageId="115" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="197" name="" description="" lineageId="118" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="200" name="" description="" lineageId="121" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="203" name="" description="" lineageId="124" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="206" name="" description="" lineageId="127" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="209" name="" description="" lineageId="130" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="212" name="" description="" lineageId="133" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="215" name="" description="" lineageId="136" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="218" name="" description="" lineageId="139" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="221" name="" description="" lineageId="142" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="224" name="" description="" lineageId="145" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="227" name="" description="" lineageId="148" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="230" name="" description="" lineageId="780" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="233" name="" description="" lineageId="783" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="236" name="" description="" lineageId="786" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
<inputColumn id="239" name="" description="" lineageId="789" usageType="readOnly" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/>
</inputColumns><externalMetadataColumns isUsed="False"/></input>
</inputs>
<outputs>
<output id="166" name="Sampling Selected Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><properties>
<property id="167" name="Selected" dataType="System.Boolean" state="default" isArray="false" description="Output for rows in the sample" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</property></properties><outputColumns>
<outputColumn id="242" name="CustomerKey" description="" lineageId="242" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="243" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">100</property></properties></outputColumn>
<outputColumn id="244" name="FirstName" description="" lineageId="244" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="245" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">103</property></properties></outputColumn>
<outputColumn id="246" name="MiddleName" description="" lineageId="246" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="247" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">106</property></properties></outputColumn>
<outputColumn id="248" name="LastName" description="" lineageId="248" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="249" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">109</property></properties></outputColumn>
<outputColumn id="250" name="NameStyle" description="" lineageId="250" precision="0" scale="0" length="0" dataType="bool" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="251" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">112</property></properties></outputColumn>
<outputColumn id="252" name="BirthDate" description="" lineageId="252" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="253" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">115</property></properties></outputColumn>
<outputColumn id="254" name="MaritalStatus" description="" lineageId="254" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="255" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">118</property></properties></outputColumn>
<outputColumn id="256" name="Gender" description="" lineageId="256" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="257" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">121</property></properties></outputColumn>
<outputColumn id="258" name="YearlyIncome" description="" lineageId="258" precision="0" scale="0" length="0" dataType="cy" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="259" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">124</property></properties></outputColumn>
<outputColumn id="260" name="TotalChildren" description="" lineageId="260" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="261" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">127</property></properties></outputColumn>
<outputColumn id="262" name="NumberChildrenAtHome" description="" lineageId="262" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="263" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">130</property></properties></outputColumn>
<outputColumn id="264" name="EnglishEducation" description="" lineageId="264" precision="0" scale="0" length="40" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="265" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">133</property></properties></outputColumn>
<outputColumn id="266" name="EnglishOccupation" description="" lineageId="266" precision="0" scale="0" length="100" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="267" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">136</property></properties></outputColumn>
<outputColumn id="268" name="HouseOwnerFlag" description="" lineageId="268" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="269" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">139</property></properties></outputColumn>
<outputColumn id="270" name="NumberCarsOwned" description="" lineageId="270" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="271" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">142</property></properties></outputColumn>
<outputColumn id="272" name="DateFirstPurchase" description="" lineageId="272" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="273" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">145</property></properties></outputColumn>
<outputColumn id="274" name="CommuteDistance" description="" lineageId="274" precision="0" scale="0" length="15" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="275" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">148</property></properties></outputColumn>
<outputColumn id="276" name="StateProvinceName" description="" lineageId="276" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="277" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">780</property></properties></outputColumn>
<outputColumn id="278" name="EnglishCountryRegionName" description="" lineageId="278" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="279" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">783</property></properties></outputColumn>
<outputColumn id="280" name="PostalCode" description="" lineageId="280" precision="0" scale="0" length="15" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"><properties>
<property id="281" name="InputColumnLineageID" dataType="System.Int32" state="default" isArray="false" description="Input column lineage ID" typeConverter="" UITypeEditor="" containsID="true" expressionType="None">786</pr