⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 run first and only once.dtsx

📁 数据仓库开发的很好的一个例子
💻 DTSX
📖 第 1 页 / 共 2 页
字号:
🔍
12 
    <control>
      <ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" />
    </control>
    <layoutobject>
      <ddsxmlobj>
        <property name="LogicalObject" value="{93d87f5f-7b08-49e1-bb5e-0da0a53af564}" vartype="8" />
        <property name="ShowConnectorSource" value="0" vartype="2" />
      </ddsxmlobj>
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="2" top="5794" logicalid="9" controlid="4" masterid="0" hint1="0" hint2="0" width="7667" height="1500" 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="00020000f31d0000dc0500000300640000000500008008000080000000002a0001000000900144420100065461686f6d61c70054006800690073002000730074006100670069006e00670020007400610062006c006500200069007300200075007300650064002000620079002000740068006500200046006100630074004f00720064006500720073000d000a007000610063006b006100670065002e00200049006600200077006500200064006f006e002700740020007000720065002d006300720065006100740065002000690074002c00200074006800650020007000610063006b006100670065000d000a00770069006c006c0020007400680072006f0077002000760061006c00690064006100740069006f006e0020006500720072006f007200730020007700680065006e002000690074002700730020006f00700065006e00650064002e000d000a0049006600200074006800650020007400610062006c00650020006500780069007300740073002c0020007400680065002000530051004c002000640072006f0070007300200069007400200061006e0064002000720065002d0063007200650061007400650073002000690074002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
  <ddscontrol controlprogid="MSDDS.Text" left="3573" top="449" logicalid="10" controlid="5" masterid="0" hint1="0" hint2="0" width="6926" height="2241" 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="000200000e1b0000c10800000300640000000500008008000080000000002a0001000000900144420100065461686f6d61e800540068006900730020007000610063006b006100670065002000630072006500610074006500730020006100200066006f006c00640065007200200061006e006400200061002000730074006100670069006e00670020007400610062006c0065002e000d000a0059006f00750020006f006e006c00790020006e00650065006400200074006f002000720075006e00200074006800650020007000610063006b0061006700650020006f006e00630065002c0020006200650066006f0072006500200079006f0075000d000a0061007400740065006d0070007400200074006f002000720075006e00200074006800650020007000610063006b006100670065002000740068006100740020006c006f0061006400730020007400680065002000640061007400610062006100730065002e000d000a004e006f007400680069006e00670020006200610064002000770069006c006c002000680061007000700065006e00200069006600200079006f0075002000720075006e00200069007400200061006700610069006e002c002000620075007400200079006f00750027006c006c000d000a0073006500650020006500720072006f00720020006d0065007300730061006700650073002e0000000000" />
    </control>
    <layoutobject>
      <ddsxmlobj />
    </layoutobject>
    <shape groupshapeid="0" groupnode="0" />
  </ddscontrol>
&lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;dwd:PersistedViewPortTop&gt;-3000&lt;/dwd:PersistedViewPortTop&gt;&lt;/dwd:DtsControlFlowDiagram&gt;&lt;/Package&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{6118C739-C13C-49BB-9BFA-5F6219062EA6}</DTS:Property><DTS:Property DTS:Name="DTSID">{3749FFD7-625E-4AE7-98A2-07D42990B333}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">&lt;ConnectionManager 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"&gt;&lt;dwd:DataSourceID&gt;MDWT AdventureWorksDW OLEDB&lt;/dwd:DataSourceID&gt;&lt;/ConnectionManager&gt;</DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{7999BEEE-C76D-4472-96B8-7DE70EA0EAB7}</DTS:Property><DTS:Property DTS:Name="DTSID">{4FE01343-41C2-4B0E-B157-DEBB2A7DBDA1}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">2</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">1033</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask, Microsoft.SqlServer.FileSystemTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">File System Task;Microsoft Corporation; Microsoft SQL Server v9; 漏 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">0</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Create SSIStemp folder</DTS:Property><DTS:Property DTS:Name="DTSID">{49506C67-5CE5-443A-890C-4EB79DB60900}</DTS:Property><DTS:Property DTS:Name="Description">File System Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask, Microsoft.SqlServer.FileSystemTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><FileSystemData TaskOperationType="CreateDirectory" OperationName="" TaskOverwriteDestFile="True" TaskSourcePath="{6FE42C76-DFF4-422E-978E-86CE33F1125E}" TaskIsSourceVariable="False" TaskDestinationPath="" TaskIsDestinationVariable="False" TaskFileAttributes="Normal"/></DTS:ObjectData></DTS:Executable>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="1"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; 漏 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">0</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Create Staging Table</DTS:Property><DTS:Property DTS:Name="DTSID">{93d87f5f-7b08-49e1-bb5e-0da0a53af564}</DTS:Property><DTS:Property DTS:Name="Description">Execute SQL Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{7999BEEE-C76D-4472-96B8-7DE70EA0EAB7}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="False" SQLTask:BypassPrepare="False" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="/*&#xA;Create staging table. You wouldn't normally do this inside the ETL system. We're doing it that way to simplify the instructions&#xA;for how to get up and running.&#xA;*/&#xA;IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FactOrders_Stage]') AND type in (N'U'))&#xA;DROP TABLE [dbo].[FactOrders_Stage]&#xA;&#xA;CREATE TABLE FactOrders_Stage (&#xA; [ProductKey] [int] NOT NULL,&#xA; [BKAccountNumber] varchar(10) NOT NULL,&#xA; [OrderDateKey] [int] NOT NULL,&#xA; [DueDateKey] [int] NOT NULL,&#xA; [OrderInfoKey] [smallint] NOT NULL,&#xA; [PromotionKey] [smallint] NOT NULL,&#xA; [CurrencyKey] [smallint] NOT NULL,&#xA; [SalesRepKey] [int] NOT NULL,&#xA; [InsertAuditKey] [int] NOT NULL,&#xA; [UpdateAuditKey] [int] NOT NULL DEFAULT ((-2)),&#xA; [SalesOrderNum] [int] NOT NULL,&#xA; [SalesOrderLineNum] [int] NOT NULL,&#xA; [SalesOrderRevisionNum] [tinyint] NOT NULL,&#xA; [OrderQty] [smallint] NULL,&#xA; [UnitPriceUSD] [money] NULL,&#xA; [ExtendedAmtUSD] [money] NULL,&#xA; [UnitPriceDiscountPct] [float] NULL,&#xA; [DiscountUSD] [money] NULL,&#xA; [ProductStdCostUSD] [money] NULL,&#xA; [TotalProductCostUSD] [money] NULL,&#xA; [SalesAmtUSD] [money] NULL,&#xA; [SalesAmtLocal] [money] NULL,&#xA; [TaxUSD] [money] NULL,&#xA; [TaxLocal] [money] NULL,&#xA; [FreightUSD] [money] NULL,&#xA; [FreightLocal] [money] NULL,&#xA; [CustomerPONum] [varchar](25) NULL,&#xA;OrderDate datetime NULL&#xA;) ON [PRIMARY]" SQLTask:ResultType="ResultSetType_None" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"/></DTS:ObjectData></DTS:Executable><DTS:Property DTS:Name="ObjectName">RUN FIRST AND ONLY ONCE</DTS:Property><DTS:Property DTS:Name="DTSID">{6118C739-C13C-49BB-9BFA-5F6219062EA6}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property></DTS:Executable>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -