Share via

3.3 Custom Component

The following package file contains a custom component. The package file deviates from the specified XSD because of the presence the custom component as described here and as shown in the full package file below.

The ExecutableType attribute value is a custom value that is specified by the custom component, as follows.

 "CustomFileCopyTask.CustomFileCopy, CustomFileCopyTask, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6d9410f0409e8e15"

The componentClassID attribute value is a custom value that is specified by the custom component and is not present in the specified XSD.

                           <component id="1" name="CalendarTransform" 
                            componentClassID="{BF01D463-7089-41EE-8F05-0A6DC17CE633}" 
                 description="Generates Roman, financial, reporting, manufacturing and IOS8601 calendar data." 
                             localeId="-1" usesDispositions="false" 
                             validateExternalMetadata="True" version="0" 
                             pipelineVersion="0" contactInfo="">
 

Each of the following properties is not a specified property in the XSD and is a custom value that is specified defined by the custom component.

                                              <property id="5" name="First day of week" 
                                dataType="System.String" state="default" 
                                isArray="false" description="Start day of logical week" 
                 typeConverter="Microsoft.Samples.SqlServer.Dts.DataFlow.FirstDayOfWeekConverter, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407" 
                                UITypeEditor="" containsID="false" 
                                expressionType="None">Tuesday</property>            
  
                               <property id="6" name="Fiscal definition" 
                                dataType="System.String" state="default" 
                                isArray="false" description=
                                "Parameter list defining fiscal calendar" 
                                typeConverter="" UITypeEditor="" containsID="false" 
                                expressionType="None">StartDay=1,StartMonth=1,YearDelta=0
                               </property>
  
                               <property id="7" name="Manufacturing definition" 
                                dataType="System.String" state="default" isArray="false" 
                         description="Parameter list defining manufacturing calendar" 
                                typeConverter="" UITypeEditor="" containsID="false" 
                                expressionType="None">StartMonth=1,StartWeek=1,Quarter=1
                               </property>
                                 <property id="8" name="Reporting definition" dataType=
                                "System.String" state="default" isArray="false" 
                                  description="Parameter list defining reporting calendar" 
                                typeConverter="" UITypeEditor="" containsID="false" 
                                expressionType="None">StartMonth=1,StartWeek=1,Pattern=445
                               </property>
                                       <property id="167" name="Attribute Type" dataType=
                                                 "System.String" state="default" isArray=
                                         "false" description="Time period attribute type" 
                                                 typeConverter=
                 "Microsoft.Samples.SqlServer.Dts.DataFlow.TimeAttributeTypeConverter, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407" 
                                                 UITypeEditor="" containsID="false" 
                                                 expressionType="None">Days</property>
                                       <property id="168" name="Attribute Part" dataType=
                                                 "System.String" state="default" isArray=
                                         "false" description="Time period attribute part" 
                                                 typeConverter=
                 "Microsoft.Samples.SqlServer.Dts.DataFlow.TimeAttributePartConverter, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407" 
                                                 UITypeEditor="" containsID="false" 
                                                 expressionType="None">Key</property>
                                       <property id="169" name="Format" dataType=
                                                 "System.String" state="default" 
                                                 isArray="false" description=
                                "Optional format string (output coerced to string)" 
                                                 typeConverter="" UITypeEditor="" 
                                                 containsID="false" expressionType="None">
                                        </property>

For detailed information about how custom components affect the defined DTSX structure, see Custom Component.

  
 <?xml version="1.0"?>
 <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" 
                 DTS:ExecutableType="SSIS.Package.2">
   <DTS:Property DTS:Name="PackageFormatVersion">2</DTS:Property>
   <DTS:Property DTS:Name="VersionComments"></DTS:Property>
   <DTS:Property DTS:Name="CreatorName">DOMAIN\username</DTS:Property>
   <DTS:Property DTS:Name="CreatorComputerName">KEVIRT01</DTS:Property>
   <DTS:Property DTS:Name="CreationDate" DTS:DataType="7">
     11/20/2007 11:29:04 AM</DTS:Property>
   <DTS:Property DTS:Name="PackageType">5</DTS:Property>
   <DTS:Property DTS:Name="ProtectionLevel">1</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">5</DTS:Property>
   <DTS:Property DTS:Name="VersionGUID">
     {18F30840-EE8E-4119-B16D-85D3DC24B6DC}</DTS:Property>
   <DTS:Property DTS:Name="EnableConfig">0</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: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">1033</DTS:Property>
   <DTS:Property DTS:Name="TransactionOption">1</DTS:Property>
   <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
   <DTS:Property DTS:Name="ObjectName">Package</DTS:Property>
   <DTS:Property DTS:Name="DTSID">{61EDFABA-B54F-4EFE-9FF2-DABDD94B9D51}
   </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:ConnectionManager>
     <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Flat File Connection Manager
     </DTS:Property>
     <DTS:Property DTS:Name="DTSID">{4F717107-732B-4C1B-AAF5-A5A31B6FECE8}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName">FLATFILE</DTS:Property>
     <DTS:ObjectData>
       <DTS:ConnectionManager>
         <DTS:Property DTS:Name="FileUsageType">0</DTS:Property>
         <DTS:Property DTS:Name="Format">FixedWidth</DTS:Property>
         <DTS:Property DTS:Name="LocaleID">1033</DTS:Property>
         <DTS:Property DTS:Name="Unicode">0</DTS:Property>
         <DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property>
         <DTS:Property DTS:Name="HeaderRowDelimiter" 
                 xml:space="preserve">_x000D__x000A_</DTS:Property>
         <DTS:Property DTS:Name="ColumnNamesInFirstDataRow">0
         </DTS:Property>
         <DTS:Property DTS:Name="RowDelimiter" xml:space="preserve">
         </DTS:Property>
         <DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property>
         <DTS:Property DTS:Name="TextQualifier">&lt;none&gt;</DTS:Property>
         <DTS:Property DTS:Name="CodePage">1252</DTS:Property>
         <DTS:Property DTS:Name="ConnectionString">
 C:\Documents and Settings\Administrator\Local Settings\Temp\f1.txt
         </DTS:Property>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">FixedWidth</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">
           </DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">24</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">4</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column 0</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
             {5EC860DF-B362-4219-A057-FFB39B58905E}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">FixedWidth</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">
           </DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">3</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">3</DTS:Property>
           <DTS:Property DTS:Name="DataType">129</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column 1</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {7657CF3B-099A-4DE3-9790-257BC29911D8}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">FixedWidth</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">
           </DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">24</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">4</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column 3</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {384A703C-66ED-4ACB-9A65-AE1218D1B72F}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">FixedWidth</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">
           </DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">23</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">7</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">DateColumn</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {E58B1BF2-BBC1-4C4E-84CE-EDB786620D1A}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">FixedWidth</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">
           </DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">30</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">135</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {42D205F3-5045-4220-8039-2D901E25061A}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
       </DTS:ConnectionManager>
     </DTS:ObjectData>
   </DTS:ConnectionManager>
   <DTS:ConnectionManager>
     <DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Sample Flat connection
     </DTS:Property>
     <DTS:Property DTS:Name="DTSID">{00F5DC11-75D6-49FC-BE02-C4984643F39A}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName">FLATFILE</DTS:Property>
     <DTS:ObjectData>
       <DTS:ConnectionManager>
         <DTS:Property DTS:Name="FileUsageType">0</DTS:Property>
         <DTS:Property DTS:Name="Format">Delimited</DTS:Property>
         <DTS:Property DTS:Name="LocaleID">1033</DTS:Property>
         <DTS:Property DTS:Name="Unicode">0</DTS:Property>
         <DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property>
         <DTS:Property DTS:Name="HeaderRowDelimiter" 
                       xml:space="preserve">_x000D__x000A_</DTS:Property>
         <DTS:Property DTS:Name="ColumnNamesInFirstDataRow">0</DTS:Property>
         <DTS:Property DTS:Name="RowDelimiter" xml:space="preserve">
         </DTS:Property>
         <DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property>
         <DTS:Property DTS:Name="TextQualifier">&lt;none&gt;</DTS:Property>
         <DTS:Property DTS:Name="CodePage">1252</DTS:Property>
         <DTS:Property DTS:Name="ConnectionString">
 C:\Documents and Settings\Administrator\Local Settings\Temp\t1.txt
         </DTS:Property>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" 
                         xml:space="preserve">_x0009_</DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">0</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">4</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column 0</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {B595CAF1-EFA8-4F91-9813-E46E9BA0B23C}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" 
                         xml:space="preserve">_x0009_</DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">0</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">3</DTS:Property>
           <DTS:Property DTS:Name="DataType">129</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column 1</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {68CD7506-DD5C-4D29-BB9E-E35F3AFCE310}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" 
                         xml:space="preserve">_x0009_</DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">0</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">7</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">DateColumn</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {95B6A9B8-2732-42A5-8091-7751E2CBE35A}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
         <DTS:FlatFileColumn>
           <DTS:Property DTS:Name="ColumnType">Delimited</DTS:Property>
           <DTS:Property DTS:Name="ColumnDelimiter" 
                         xml:space="preserve">_x000D__x000A_</DTS:Property>
           <DTS:Property DTS:Name="ColumnWidth">0</DTS:Property>
           <DTS:Property DTS:Name="MaximumWidth">0</DTS:Property>
           <DTS:Property DTS:Name="DataType">4</DTS:Property>
           <DTS:Property DTS:Name="DataPrecision">0</DTS:Property>
           <DTS:Property DTS:Name="DataScale">0</DTS:Property>
           <DTS:Property DTS:Name="TextQualified">-1</DTS:Property>
           <DTS:Property DTS:Name="ObjectName">Column 3</DTS:Property>
           <DTS:Property DTS:Name="DTSID">
 {A3C6406D-E017-44A7-A217-8171E5E04326}</DTS:Property>
           <DTS:Property DTS:Name="Description"></DTS:Property>
           <DTS:Property DTS:Name="CreationName"></DTS:Property>
         </DTS:FlatFileColumn>
       </DTS:ConnectionManager>
     </DTS:ObjectData>
   </DTS:ConnectionManager>
   <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=
 "CustomFileCopyTask.CustomFileCopy, CustomFileCopyTask, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6d9410f0409e8e15" 
     DTS:ThreadHint="0">
     <DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property>
     <DTS:Property DTS:Name="ExecutionAddress"></DTS:Property>
     <DTS:Property DTS:Name="TaskContact">
       CustomFileCopyTask, Copyright (c) Microsoft</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:Property DTS:Name="ObjectName">CustomFileCopyTask</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{E4168410-1CEC-4CC2-975D-9349F44ABEDB}
     </DTS:Property>
     <DTS:Property DTS:Name="Description">CustomFileCopyTask</DTS:Property>
     <DTS:Property DTS:Name="CreationName">
 CustomFileCopyTask.CustomFileCopy, CustomFileCopyTask, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6d9410f0409e8e15
     </DTS:Property>
     <DTS:Property DTS:Name="DisableEventHandlers">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:ObjectData>
       <InnerObject>
         <DestFileName Type="8" Value="%TEMP%\t1.txt"/>
         <SourceFileName Type="8" Value="%TEMP%\SampleCurrencyData.txt"/>
       </InnerObject>
     </DTS:ObjectData>
   </DTS:Executable>
   <DTS:Executable DTS:ExecutableType="SSIS.Pipeline.2">
     <DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property>
     <DTS:Property DTS:Name="ExecutionAddress"></DTS:Property>
     <DTS:Property DTS:Name="TaskContact">
 Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v9; (C) 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:Property DTS:Name="ObjectName">Data Flow Task</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{23B174F1-23C2-49F9-8512-03D5A2677E67}
     </DTS:Property>
     <DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property>
     <DTS:Property DTS:Name="CreationName">DTS.Pipeline.1</DTS:Property>
     <DTS:Property DTS:Name="DisableEventHandlers">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:ObjectData>
       <pipeline id="0" name="pipelineXml" description="pipelineXml" 
        defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize=
        "10485760" BLOBTempStoragePath="" bufferTempStoragePath="" 
                 runInOptimizedMode="true">
         <components>
           <component id="20" name="Flat File Source" componentClassID=
           "{5ACD952A-F16A-41D8-A681-713640837664}" description=
           "Flat File Source" localeId="1033" usesDispositions="true" 
           validateExternalMetadata="True" version="1" pipelineVersion="0" 
           contactInfo=
 "Flat File Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1">
             <properties>
               <property id="26" name="RetainNulls" dataType=
               "System.Boolean" state="default" isArray="false" 
               description="Specifies whether zero-length columns 
               are treated as null." typeConverter="" UITypeEditor="" 
               containsID="false" expressionType="None">false</property>
               <property id="27" name="FileNameColumnName" dataType="System.String" state="default" isArray="false" description="Specifies the name of an output column containing the file name. If no name is specified, no output column containing the file name will be generated." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
             </properties>
             <connections>
               <connection id="25" name="FlatFileConnection" description="" 
            connectionManagerID="{00F5DC11-75D6-49FC-BE02-C4984643F39A}"/>
             </connections>
             <outputs>
               <output id="21" name="Flat File 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="45" name="Column 0" description="" 
                    lineageId="45" precision="0" scale="0" length="0" 
                     dataType="r4" codePage="0" sortKeyPosition="0" 
                     comparisonFlags="0" specialFlags="0" 
                     errorOrTruncationOperation="Conversion" 
                     errorRowDisposition="FailComponent" 
                     truncationRowDisposition="FailComponent" 
                     externalMetadataColumnId="44">
                     <properties>
                       <property id="46" name="FastParse" dataType=
                        "System.Boolean" state="default" isArray="false" 
 description="Indicates whether the column uses the faster, locale-neutral parsing routines." 
                        typeConverter="" UITypeEditor="" containsID="false"
                        expressionType="None">false</property>
                       <property id="47" name="UseBinaryFormat" dataType=
                        "System.Boolean" state="default" isArray="false" 
               description="Indicates whether the data is in binary format." 
                        typeConverter="" UITypeEditor="" containsID="false" 
                        expressionType="None">false</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="49" name="Column 1" description="" 
                    lineageId="49" precision="0" scale="0" length="3" 
                    dataType="str" codePage="1252" sortKeyPosition="0" 
                    comparisonFlags="0" specialFlags="0" 
                     errorOrTruncationOperation="Conversion"
                     errorRowDisposition="FailComponent" 
                     truncationRowDisposition="FailComponent" 
                     externalMetadataColumnId="48">
                     <properties>
                       <property id="50" name="FastParse" dataType=
                        "System.Boolean" state="default" isArray="false" 
 description="Indicates whether the column uses the faster, locale-neutral parsing routines." 
                        typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">false</property>
                       <property id="51" name="UseBinaryFormat" dataType=
                        "System.Boolean" state="default" isArray="false" 
 description="Indicates whether the data is in binary format." 
                        typeConverter="" UITypeEditor="" containsID="false"
                        expressionType="None">false</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="57" name="Column 3" description="" 
                    lineageId="57" precision="0" scale="0" length="0"
                    dataType="r4" codePage="0" sortKeyPosition="0" 
                    comparisonFlags="0" specialFlags="0" 
                     errorOrTruncationOperation="Conversion"
                     errorRowDisposition="FailComponent" 
                     truncationRowDisposition="FailComponent" 
                     externalMetadataColumnId="56">
                     <properties>
                       <property id="58" name="FastParse" dataType=
                        "System.Boolean" state="default" isArray="false" 
 description="Indicates whether the column uses the faster, locale-neutral parsing routines." 
                        typeConverter="" UITypeEditor="" containsID="false"
                        expressionType="None">false</property>
                       <property id="59" name="UseBinaryFormat" 
                         dataType="System.Boolean" state="default" isArray=
       "false" description="Indicates whether the data is in binary format." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">false</property>
                     </properties>
                   </outputColumn>
                   <outputColumn id="129" name="DateColumn" description="" 
                    lineageId="129" precision="0" scale="0" length="0" 
                    dataType="date" codePage="0" sortKeyPosition="0" 
                    comparisonFlags="0" specialFlags="0" 
                    errorOrTruncationOperation="Conversion" 
                    errorRowDisposition="FailComponent" 
                    truncationRowDisposition="FailComponent" 
                    externalMetadataColumnId="128">
                     <properties>
                       <property id="130" name="FastParse" dataType=
                        "System.Boolean" state="default" isArray="false" 
 description="Indicates whether the column uses the faster, locale-neutral parsing routines." 
                        typeConverter="" UITypeEditor="" containsID="false"
                        expressionType="None">false</property>
                       <property id="131" name="UseBinaryFormat" dataType=
                       "System.Boolean" state="default" isArray="false" 
 description="Indicates whether the data is in binary format." 
                        typeConverter="" UITypeEditor="" containsID="false"
                        expressionType="None">false</property>
                     </properties>
                   </outputColumn>
                 </outputColumns>
                 <externalMetadataColumns isUsed="True">
                   <externalMetadataColumn id="44" name="Column 0" 
                    description="" precision="0" scale="0" length="0" 
                    dataType="r4" codePage="0"/>
                   <externalMetadataColumn id="48" name="Column 1" 
                    description="" precision="0" scale="0" length="3"
                    dataType="str" codePage="1252"/>
                   <externalMetadataColumn id="56" name="Column 3" 
                    description="" precision="0" scale="0" length="0" 
                    dataType="r4" codePage="0"/>
                   <externalMetadataColumn id="128" name="DateColumn" 
                    description="" precision="0" scale="0" length="0" 
                    dataType="date" codePage="0"/>
                 </externalMetadataColumns>
               </output>
               <output id="22" name="Flat File Source Error Output" 
                 description="" exclusionGroup="0" synchronousInputId="0" 
                 deleteOutputOnPathDetached="false" hasSideEffects="false" 
                  dangling="false" isErrorOut="true" isSorted="false" 
                  errorOrTruncationOperation="" errorRowDisposition="NotUsed"
                  truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="60" name=
                    "Flat File Source Error Output Column" 
                    description="Flat File Source Error Output Column" 
                    lineageId="60" precision="0" scale="0" length="0" 
                    dataType="text" codePage="1252" sortKeyPosition="0" 
                    comparisonFlags="0" specialFlags="0" 
                    errorOrTruncationOperation="" errorRowDisposition=
                    "NotUsed" truncationRowDisposition="NotUsed" 
                    externalMetadataColumnId="0"/>
                   <outputColumn id="23" name="ErrorCode" description="" 
                    lineageId="23" precision="0" scale="0" length="0" 
                    dataType="i4" codePage="0" sortKeyPosition="0" 
                    comparisonFlags="0" specialFlags="1" 
                    errorOrTruncationOperation="" 
                    errorRowDisposition="NotUsed" truncationRowDisposition=
                    "NotUsed" externalMetadataColumnId="0"/>
                   <outputColumn id="24" name="ErrorColumn" description="" 
                    lineageId="24" precision="0" scale="0" length="0" 
                    dataType="i4" codePage="0" sortKeyPosition="0" 
                    comparisonFlags="0" specialFlags="2" 
                    errorOrTruncationOperation="" errorRowDisposition=
                    "NotUsed" truncationRowDisposition="NotUsed" 
                    externalMetadataColumnId="0"/>
                 </outputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
           <component id="1" name="CalendarTransform" 
            componentClassID="{BF01D463-7089-41EE-8F05-0A6DC17CE633}" 
 description="Generates Roman, financial, reporting, manufacturing and IOS8601 calendar data." 
             localeId="-1" usesDispositions="false" 
             validateExternalMetadata="True" version="0" 
             pipelineVersion="0" contactInfo="">
             <properties>
               <property id="5" name="First day of week" 
                dataType="System.String" state="default" 
                isArray="false" description="Start day of logical week" 
 typeConverter="Microsoft.Samples.SqlServer.Dts.DataFlow.FirstDayOfWeekConverter, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407" 
                UITypeEditor="" containsID="false" 
                expressionType="None">Tuesday</property>
               <property id="6" name="Fiscal definition" 
                dataType="System.String" state="default" 
                isArray="false" description=
                "Parameter list defining fiscal calendar" 
                typeConverter="" UITypeEditor="" containsID="false" 
                expressionType="None">StartDay=1,StartMonth=1,YearDelta=0
               </property>
               <property id="7" name="Manufacturing definition" 
                dataType="System.String" state="default" isArray="false" 
         description="Parameter list defining manufacturing calendar" 
                typeConverter="" UITypeEditor="" containsID="false" 
                expressionType="None">StartMonth=1,StartWeek=1,Quarter=1
               </property>
               <property id="8" name="Reporting definition" dataType=
                "System.String" state="default" isArray="false" 
     description="Parameter list defining reporting calendar" 
                typeConverter="" UITypeEditor="" containsID="false" 
                expressionType="None">StartMonth=1,StartWeek=1,Pattern=445
               </property>
               <property id="11" name="UserComponentTypeName" 
                dataType="System.String" state="default" isArray="false" 
                description="" typeConverter="" UITypeEditor="" 
                containsID="false" expressionType="None">
 Microsoft.Samples.SqlServer.Dts.DataFlow.CalendarTransform, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407
 </property>
             </properties>
             <inputs>
               <input id="9" name="CalendarInput" description=
                "Synchronous input columns for component" 
                      hasSideEffects="false" dangling="false" 
                      errorOrTruncationOperation="" errorRowDisposition=
                      "NotUsed" truncationRowDisposition="NotUsed">
                 <inputColumns>
                   <inputColumn id="165" name="DateColumn" description="" 
                                lineageId="129" usageType="readWrite" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="0"/>
                 </inputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </input>
             </inputs>
             <outputs>
               <output id="10" name="CalendarOutput" 
           description="Synchronous output columns for component" 
                       exclusionGroup="0" synchronousInputId="9" 
                       deleteOutputOnPathDetached="false" hasSideEffects=
                       "false" dangling="false" isErrorOut="false" 
                       isSorted="false" errorOrTruncationOperation="" 
                       errorRowDisposition="NotUsed" 
                       truncationRowDisposition="NotUsed">
                 <outputColumns>
                   <outputColumn id="166" name="Column" description="" 
                                 lineageId="166" 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="167" name="Attribute Type" dataType=
                                 "System.String" state="default" isArray=
                         "false" description="Time period attribute type" 
                                 typeConverter=
 "Microsoft.Samples.SqlServer.Dts.DataFlow.TimeAttributeTypeConverter, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">Days</property>
                       <property id="168" name="Attribute Part" dataType=
                                 "System.String" state="default" isArray=
                         "false" description="Time period attribute part" 
                                 typeConverter=
 "Microsoft.Samples.SqlServer.Dts.DataFlow.TimeAttributePartConverter, CalendarTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e9fac57941009407" 
                                 UITypeEditor="" containsID="false" 
                                 expressionType="None">Key</property>
                       <property id="169" name="Format" dataType=
                                 "System.String" state="default" 
                                 isArray="false" description=
                "Optional format string (output coerced to string)" 
                                 typeConverter="" UITypeEditor="" 
                                 containsID="false" expressionType="None">
                        </property>
                     </properties>
                   </outputColumn>
                 </outputColumns>
                 <externalMetadataColumns isUsed="False"/>
               </output>
             </outputs>
           </component>
           <component id="170" name="Flat File Destination" 
            componentClassID="{D658C424-8CF0-441C-B3C4-955E183B7FBA}" 
                      description="Flat File Destination" localeId="1033" 
                 usesDispositions="false" validateExternalMetadata="True" 
                      version="0" pipelineVersion="0" contactInfo=
 "Flat File Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
             <properties>
               <property id="173" name="Overwrite" dataType="System.Boolean"
                         state="default" isArray="false" description=
 "Specifies whether the data will overwrite or append to the destination file." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="None">true</property>
               <property id="174" name="Header" dataType="System.Null" 
                         state="default" isArray="false" description=
 "Specifies the text to write to the destination file before any data is written." 
                         typeConverter="" UITypeEditor="" containsID="false"
                         expressionType="Notify"/>
             </properties>
             <connections>
               <connection id="172" name="FlatFileConnection" description=""
            connectionManagerID="{4F717107-732B-4C1B-AAF5-A5A31B6FECE8}"/>
             </connections>
             <inputs>
               <input id="171" name="Flat File Destination Input" 
                      description="" hasSideEffects="true" dangling="false"
                      errorOrTruncationOperation="" errorRowDisposition=
                      "NotUsed" truncationRowDisposition="NotUsed">
                 <inputColumns>
                   <inputColumn id="191" name="" description="" lineageId
                                ="45" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="186"/>
                   <inputColumn id="192" name="" description="" 
                                lineageId="49" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="187"/>
                   <inputColumn id="193" name="" description="" 
                                lineageId="57" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="188"/>
                   <inputColumn id="194" name="" description="" 
                                lineageId="129" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="189"/>
                   <inputColumn id="195" name="" description="" 
                                lineageId="166" usageType="readOnly" 
                                errorOrTruncationOperation="" 
                                errorRowDisposition="NotUsed" 
                                truncationRowDisposition="NotUsed" 
                                externalMetadataColumnId="190"/>
                 </inputColumns>
                 <externalMetadataColumns isUsed="True">
                   <externalMetadataColumn id="186" name="Column 0" 
                             description="" precision="0" scale="0" 
                             length="0" dataType="r4" codePage="0"/>
                   <externalMetadataColumn id="187" name="Column 1" 
                              description="" precision="0" scale="0"
                              length="3" dataType="str" codePage="1252"/>
                   <externalMetadataColumn id="188" name="Column 3" 
                               description="" precision="0" scale="0" 
                               length="0" dataType="r4" codePage="0"/>
                   <externalMetadataColumn id="189" name="DateColumn" 
                               description="" precision="0" scale="0" 
                               length="0" dataType="date" codePage="0"/>
                   <externalMetadataColumn id="190" name="Column" 
                               description="" precision="0" scale="0" 
                               length="0" dataType="dbTimeStamp" 
                               codePage="0"/>
                 </externalMetadataColumns>
               </input>
             </inputs>
           </component>
         </components>
         <paths>
           <path id="61" name="Flat File Source Output" 
                 description="" startId="21" endId="9"/>
           <path id="180" name="CalendarOutput" 
                 description="" startId="10" endId="171"/>
         </paths>
       </pipeline>
     </DTS:ObjectData>
   </DTS:Executable>
   <DTS:Executable DTS:ExecutableType=
 "Microsoft.SqlServer.Dts.Tasks.FileSystemTask.FileSystemTask, Microsoft.SqlServer.FileSystemTask, Version=10.0.0.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">-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:Property DTS:Name="ObjectName">File Delete Task</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{36115195-BDBC-4265-977F-5579CB1542CE}
     </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: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:ObjectData>
       <FileSystemData TaskOperationType="DeleteFile" OperationName="" 
                       TaskOverwriteDestFile="False" 
             TaskSourcePath="{00F5DC11-75D6-49FC-BE02-C4984643F39A}" 
             TaskIsSourceVariable="False" TaskDestinationPath="" 
             TaskIsDestinationVariable="False" TaskFileAttributes="Normal"/>
     </DTS:ObjectData>
   </DTS:Executable>
   <DTS:PrecedenceConstraint>
     <DTS:Property DTS:Name="Value">0</DTS:Property>
     <DTS:Property DTS:Name="EvalOp">2</DTS:Property>
     <DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property>
     <DTS:Property DTS:Name="Expression"></DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Constraint</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {ECFD7682-860A-4F39-BF2A-37C0C23C8D39}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:Executable IDREF="{E4168410-1CEC-4CC2-975D-9349F44ABEDB}" 
                     DTS:IsFrom="-1"/>
     <DTS:Executable IDREF="{23B174F1-23C2-49F9-8512-03D5A2677E67}" 
                     DTS:IsFrom="0"/>
   </DTS:PrecedenceConstraint>
   <DTS:PrecedenceConstraint>
     <DTS:Property DTS:Name="Value">0</DTS:Property>
     <DTS:Property DTS:Name="EvalOp">2</DTS:Property>
     <DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property>
     <DTS:Property DTS:Name="Expression"></DTS:Property>
     <DTS:Property DTS:Name="ObjectName">Constraint 1</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{380B124F-4D04-42F1-A9D5-2BA4AF584DB2}
     </DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
     <DTS:Executable IDREF="{23B174F1-23C2-49F9-8512-03D5A2677E67}" 
                     DTS:IsFrom="-1"/>
     <DTS:Executable IDREF="{36115195-BDBC-4265-977F-5579CB1542CE}" 
                     DTS:IsFrom="0"/>
   </DTS:PrecedenceConstraint>
   <DTS:PackageVariable>
     <DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8">
       &lt;TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsDataFlowDiagram&gt;&lt;dwd:BoundingTop&gt;1000&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
       &lt;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="15" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1000" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="34131" y="18600" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="0" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
       &lt;font&gt;
       &lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
       &lt;/font&gt;
       &lt;mouseicon&gt;
       &lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
       &lt;/mouseicon&gt;
       &lt;/diagram&gt;
       &lt;layoutmanager&gt;
       &lt;ddsxmlobj /&gt;
       &lt;/layoutmanager&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Generates Roman, financial, reporting, manufacturing and IOS8601 calendar data." left="1587" top="9260" logicalid="6" controlid="1" masterid="0" hint1="0" hint2="0" width="3704" 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"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="00080000780e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{23B174F1-23C2-49F9-8512-03D5A2677E67}/components/1" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Flat File Source" left="0" top="2328" logicalid="7" 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"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{23B174F1-23C2-49F9-8512-03D5A2677E67}/components/20" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="1400" top="3093" logicalid="8" controlid="3" masterid="0" hint1="0" hint2="0" width="2439" height="6667" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{23B174F1-23C2-49F9-8512-03D5A2677E67}/paths/61" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="2" destid="1" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="1799" y="3492" /&gt;
       &lt;point x="1799" y="6376" /&gt;
       &lt;point x="3439" y="6376" /&gt;
       &lt;point x="3439" y="9260" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Flat File Destination" left="4366" top="13944" logicalid="9" 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"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{23B174F1-23C2-49F9-8512-03D5A2677E67}/components/170" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="3040" top="10025" logicalid="10" controlid="5" masterid="0" hint1="0" hint2="0" width="3525" height="4419" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{23B174F1-23C2-49F9-8512-03D5A2677E67}/paths/180" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="1" destid="4" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="3439" y="10424" /&gt;
       &lt;point x="3439" y="12184" /&gt;
       &lt;point x="6165" y="12184" /&gt;
       &lt;point x="6165" y="13944" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;/dds&gt;&lt;/dwd:Layout&gt;&lt;dwd:PersistedViewPortLeft&gt;-1000&lt;/dwd:PersistedViewPortLeft&gt;&lt;/dwd:DtsDataFlowDiagram&gt;&lt;/TaskHost&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {23B174F1-23C2-49F9-8512-03D5A2677E67}</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {4E58A203-3C53-415B-AC2D-8E70958FDA9C}</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;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DestinationName&gt;Flat File Destination Input&lt;/dwd:DestinationName&gt;&lt;dwd:SourceName&gt;CalendarOutput&lt;/dwd:SourceName&gt;&lt;/PipelinePath&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">{23B174F1-23C2-49F9-8512-03D5A2677E67}-180</DTS:Property>
     <DTS:Property DTS:Name="DTSID">{39EC5E29-C552-4771-A608-54CD23A218E8}</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;PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
       xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" 
       xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" 
       xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DestinationName&gt;CalendarInput&lt;/dwd:DestinationName&gt;&lt;dwd:SourceName&gt;Flat File Source Output&lt;/dwd:SourceName&gt;&lt;/PipelinePath&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {23B174F1-23C2-49F9-8512-03D5A2677E67}-61</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {2C2FBCB9-7EC6-4D0A-A352-0323E0EBE5E6}</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;PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:EvalOp&gt;Constraint&lt;/dwd:EvalOp&gt;&lt;/PrecedenceConstraint&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {380B124F-4D04-42F1-A9D5-2BA4AF584DB2}</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {70E7F0E0-0650-48D3-AD12-02695CEFE9B4}</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;Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:DtsControlFlowDiagram&gt;&lt;dwd:BoundingLeft&gt;1000&lt;/dwd:BoundingLeft&gt;&lt;dwd:BoundingTop&gt;1000&lt;/dwd:BoundingTop&gt;&lt;dwd:Layout&gt;&lt;dds&gt;
       &lt;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="11" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="0" scrolltop="0" gridx="150" gridy="150" marginx="1000" marginy="1000" zoom="100" x="34131" y="19526" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="1" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"&gt;
       &lt;font&gt;
       &lt;ddsxmlobjectstreamwrapper binary="01010000900180380100065461686f6d61" /&gt;
       &lt;/font&gt;
       &lt;mouseicon&gt;
       &lt;ddsxmlobjectstreamwrapper binary="6c74000000000000" /&gt;
       &lt;/mouseicon&gt;
       &lt;/diagram&gt;
       &lt;layoutmanager&gt;
       &lt;ddsxmlobj /&gt;
       &lt;/layoutmanager&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Data Flow Task" left="3677" top="4095" logicalid="2" controlid="1" 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"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{23B174F1-23C2-49F9-8512-03D5A2677E67}" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="CustomFileCopyTask" left="3386" top="1032" logicalid="5" 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"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{E4168410-1CEC-4CC2-975D-9349F44ABEDB}" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="File System Task" left="3678" top="8334" logicalid="7" controlid="6" 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"&gt;
       &lt;control&gt;
       &lt;ddsxmlobjectstreaminitwrapper binary="000800000e0e00008c040000" /&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{36115195-BDBC-4265-977F-5579CB1542CE}" vartype="8" /&gt;
       &lt;property name="ShowConnectorSource" value="0" vartype="2" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;shape groupshapeid="0" groupnode="0" /&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="4786" top="1797" logicalid="9" controlid="8" masterid="0" hint1="0" hint2="0" width="1090" height="2798" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{ECFD7682-860A-4F39-BF2A-37C0C23C8D39}" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="4" destid="1" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="5185" y="2196" /&gt;
       &lt;point x="5185" y="3145" /&gt;
       &lt;point x="5476" y="3145" /&gt;
       &lt;point x="5476" y="4095" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;ddscontrol controlprogid="MSDDS.Polyline" left="5077" top="4860" logicalid="10" controlid="9" masterid="0" hint1="0" hint2="0" width="800" height="3974" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"&gt;
       &lt;control&gt;
       &lt;ddsxmlobj&gt;
       &lt;polyline endtypedst="3" endtypesrc="1" usercolor="32768" linestyle="0" linerender="2" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/control&gt;
       &lt;layoutobject&gt;
       &lt;ddsxmlobj&gt;
       &lt;property name="LogicalObject" value="{380B124F-4D04-42F1-A9D5-2BA4AF584DB2}" vartype="8" /&gt;
       &lt;property name="Virtual" value="0" vartype="11" /&gt;
       &lt;property name="VisibleAP" value="0" vartype="3" /&gt;
       &lt;/ddsxmlobj&gt;
       &lt;/layoutobject&gt;
       &lt;connector lineroutestyle="Microsoft.DataWarehouse.Layout.GraphLayout" sourceid="1" destid="6" sourceattachpoint="7" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="2" relatedid="0" virtual="0"&gt;
       &lt;point x="5476" y="5259" /&gt;
       &lt;point x="5476" y="6796" /&gt;
       &lt;point x="5477" y="6796" /&gt;
       &lt;point x="5477" y="8334" /&gt;
       &lt;/connector&gt;
       &lt;/ddscontrol&gt;
       &lt;/dds&gt;&lt;/dwd:Layout&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">
       {61EDFABA-B54F-4EFE-9FF2-DABDD94B9D51}</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {05D4BDFA-476A-4364-AF28-B7E789B5B5C4}</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;PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"&gt;&lt;dwd:EvalOp&gt;Constraint&lt;/dwd:EvalOp&gt;&lt;/PrecedenceConstraint&gt;
     </DTS:Property>
     <DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property>
     <DTS:Property DTS:Name="ObjectName">
       {ECFD7682-860A-4F39-BF2A-37C0C23C8D39}</DTS:Property>
     <DTS:Property DTS:Name="DTSID">
       {0F16D98D-E992-4013-AFB9-179B19A88AAE}</DTS:Property>
     <DTS:Property DTS:Name="Description"></DTS:Property>
     <DTS:Property DTS:Name="CreationName"></DTS:Property>
   </DTS:PackageVariable>
 </DTS:Executable>