📄 master_facts.dtsx
字号:
<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property><DTS:Property DTS:Name="VersionComments"></DTS:Property><DTS:Property DTS:Name="CreatorName">JOYSRV-01\Joy Mundy</DTS:Property><DTS:Property DTS:Name="CreatorComputerName">JOYSRV-01</DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">7/14/2005 8:35:36 AM</DTS:Property><DTS:Property DTS:Name="PackageType">5</DTS:Property><DTS:Property DTS:Name="ProtectionLevel">0</DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</DTS:Property><DTS:Property DTS:Name="VersionMajor">1</DTS:Property><DTS:Property DTS:Name="VersionMinor">0</DTS:Property><DTS:Property DTS:Name="VersionBuild">53</DTS:Property><DTS:Property DTS:Name="VersionGUID">{34E87B76-96EB-4299-9F56-0406CF9B516B}</DTS:Property><DTS:Property DTS:Name="EnableConfig">-1</DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</DTS:Property>
<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">FactExchangeRates.dtsx</DTS:Property><DTS:Property DTS:Name="DTSID">{66B13727-C8FE-48EB-A7E4-6704E325C3D6}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">FILE</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="FileUsageType">0</DTS:Property><DTS:Property DTS:Name="ConnectionString">C:\MDWT_Projects\MDWT_AdventureWorks_SSIS\MDWT_AdventureWorks_SSIS\FactExchangeRates.dtsx</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">FactOrders.dtsx</DTS:Property><DTS:Property DTS:Name="DTSID">{8C77BAFF-2DA3-4D0F-97C8-6A8EA4B72AC2}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">FILE</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="FileUsageType">0</DTS:Property><DTS:Property DTS:Name="ConnectionString">C:\MDWT_Projects\MDWT_AdventureWorks_SSIS\MDWT_AdventureWorks_SSIS\FactOrders.dtsx</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">MDWT AdventureWorksDW dotNet</DTS:Property><DTS:Property DTS:Name="DTSID">{A7027305-6C19-49BF-B462-C5F17F0D5CCE}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">ADO.NET:System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="ConnectionString">Data Source=.;Initial Catalog=MDWT_AdventureWorksDW;Integrated Security=True;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">SSIStemp</DTS:Property><DTS:Property DTS:Name="DTSID">{1B98A169-C087-42BE-926F-2CC8F992DD7A}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">FILE</DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="FileUsageType">3</DTS:Property><DTS:Property DTS:Name="ConnectionString">c:\SSIStemp</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>
<DTS:Configuration><DTS:Property DTS:Name="ConfigurationType">0</DTS:Property><DTS:Property DTS:Name="ConfigurationString">PkgExecKey</DTS:Property><DTS:Property DTS:Name="ConfigurationVariable">\Package.Variables[User::ParentPkgExecKey].Properties[Value]</DTS:Property><DTS:Property DTS:Name="ObjectName">ParentPkgExecKey</DTS:Property><DTS:Property DTS:Name="DTSID">{9BBF012C-4B46-4050-AC09-47C8C59129E3}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Configuration>
<DTS:Configuration><DTS:Property DTS:Name="ConfigurationType">0</DTS:Property><DTS:Property DTS:Name="ConfigurationString">ExtractStartDate</DTS:Property><DTS:Property DTS:Name="ConfigurationVariable">\Package.Variables[User::ExtractStartDate].Properties[Value]</DTS:Property><DTS:Property DTS:Name="ObjectName">ExtractStartDate</DTS:Property><DTS:Property DTS:Name="DTSID">{7A18BE98-47B4-4DE3-B327-9804F6B0D47A}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Configuration>
<DTS:Configuration><DTS:Property DTS:Name="ConfigurationType">0</DTS:Property><DTS:Property DTS:Name="ConfigurationString">ExtractStopDate</DTS:Property><DTS:Property DTS:Name="ConfigurationVariable">\Package.Variables[User::ExtractStopDate].Properties[Value]</DTS:Property><DTS:Property DTS:Name="ObjectName">ExtractStopDate</DTS:Property><DTS:Property DTS:Name="DTSID">{E3FD6AE0-BB59-4DF6-ACA6-794E2B222F33}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:Configuration>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:BoundingLeft>-6254</dwd:BoundingLeft><dwd:BoundingTop>-22</dwd:BoundingTop><dwd:Layout><dds>
<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="Microsoft.DataWarehouse.Layout.GraphLayout" defaultlineroute="Microsoft.DataWarehouse.Layout.GraphLayout" version="7" nextobject="34" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-7254" scrolltop="-667" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="20638" y="12488" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">
<font>
<ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" />
</font>
<mouseicon>
<ddsxmlobjectstreamwrapper binary="6c74000000000000" />
</mouseicon>
</diagram>
<layoutmanager>
<ddsxmlobj />
</layoutmanager>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="468" top="1632" logicalid="16" controlid="1" masterid="14" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="0" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{67ef08f7-d6ad-411b-9505-8ee8683d346e}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="8743" top="11912" logicalid="17" controlid="2" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{c80cddbd-ef34-4064-b0f6-5a5b0eb715d9}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="MSDDS.Text" left="5085" top="-8" logicalid="18" controlid="3" masterid="0" hint1="0" hint2="0" width="16239" height="2612" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000200006f3f0000340a00000300640000000500008008000080000000002a0001000000900144420100065461686f6d61ea01540068006900730020007000610063006b00610067006500200069007300200074006800650020006d006100730074006500720020007000610063006b00610067006500200074006800610074002000720075006e00730020007400680065002000660061006300740020006c006f006100640073002e0020005400680065002000640069006d0065006e00730069006f006e0073002000730068006f0075006c00640020006200650020006c006f0061006400650064002000460049005200530054002e000d000a000d000a004c006f006f006b002000610074002000740068006500200043006f006e006e0065006300740069006f006e0020004d0061006e00610067006500720073002000770069006e0064006f0077002000620065006c006f00770020007400680069007300200077006f0072006b00730070006100630065003a00200079006f0075002000630061006e00200073006500650020006100200063006f006e006e0065006300740069006f006e00200074006f002000650061006300680020007000610063006b006100670065002e002000570065002000610072006500200061007300730075006d0069006e0067000d000a0079006f007500270076006500200063006f007000690065006400200064006f0077006e002000740068006500200073006f006c007500740069006f006e00200061006e006400200073006f007400720065006400200074006800650020007000610063006b006100670065007300200069006e002000610020006400690072006500630074006f007200790020000d000a0063003a005c006d006400770074005f00700072006f006a0065006300740073005c006d006400770074005f0061006400760065006e00740075007200650077006f0072006b0073005f0073007300690073005c006d006400770074005f0061006400760065006e00740075007200650077006f0072006b0073005f0073007300690073002e00200049006600200079006f00750020007000750074002000740068006500200073006f006c007500740069006f006e00200073006f006d00650077006800650072006500200065006c00730065002c002000730069006d0070006c0079000d000a0067006f00200069006e0074006f002000650061006300680020006f00660020007400680065002000660069006c006500200063006f006e006e0065006300740069006f006e0073002c00200061006e006400200070006f0069006e007400200069007400200074006f002000740068006500200063006f007200720065006300740020006c006f0063006100740069006f006e002e0020000d000a0000000000" />
</control>
<layoutobject>
<ddsxmlobj />
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute Package Task" left="6832" top="7294" logicalid="19" controlid="4" masterid="0" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
</control>
<layoutobject>
<ddsxmlobj>
<property name="LogicalObject" value="{34459073-A3C7-42FA-86AD-3540F3D163F2}" vartype="8" />
<property name="ShowConnectorSource" value="0" vartype="2" />
</ddsxmlobj>
</layoutobject>
<shape groupshapeid="0" groupnode="0" />
</ddscontrol>
<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Execute SQL Task" left="636" top="5587" logicalid="20" controlid="5" masterid="14" hint1="0" hint2="0" width="3598" height="1164" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="0" snaptogrid="0">
<control>
<ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
</control>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -