<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="5/5/2013 6:08:14 PM"
  DTS:CreationName="SSIS.Package.3"
  DTS:CreatorComputerName="REZA-VAIO"
  DTS:CreatorName="REZA-VAIO\Reza"
  DTS:DTSID="{8FA7D124-E3A7-4447-AEE5-70BDC2928BF9}"
  DTS:ExecutableType="SSIS.Package.3"
  DTS:LastModifiedProductVersion="11.0.3360.12"
  DTS:LocaleID="1033"
  DTS:ObjectName="Package"
  DTS:PackageType="5"
  DTS:VersionBuild="3"
  DTS:VersionGUID="{077B76E7-7803-4899-9F76-ED8231D685D4}">
  <DTS:Property
    DTS:Name="PackageFormatVersion">6</DTS:Property>
  <DTS:ConnectionManagers>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[Excel Connection Manager]"
      DTS:CreationName="EXCEL"
      DTS:DTSID="{D809CE20-66F1-4BC9-B301-3F8C76290E09}"
      DTS:ObjectName="Excel Connection Manager">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:ConnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Dropbox\Reza\Dropbox\PACKTPUB_SHARE\05_CHAPTERS\Chapter 05\Source Code\Product Categories.xlsx;Extended Properties=&quot;Excel 12.0 XML;HDR=YES&quot;;" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[LocalHost.MDS]"
      DTS:CreationName="OLEDB"
      DTS:DTSID="{604A6D7D-BD7D-4336-AB92-FB79168E1DCC}"
      DTS:ObjectName="LocalHost.MDS">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:ConnectionString="Data Source=.;Initial Catalog=MDS;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables>
    <DTS:Variable
      DTS:CreationName=""
      DTS:DTSID="{A97A942A-F204-4F48-8174-8871E22D5688}"
      DTS:IncludeInDebugDump="2345"
      DTS:Namespace="User"
      DTS:ObjectName="BatchTag">
      <DTS:VariableValue
        DTS:DataType="8"
        xml:space="preserve"></DTS:VariableValue>
    </DTS:Variable>
  </DTS:Variables>
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\Import Data Into Stage Table"
      DTS:CreationName="{5918251B-2970-45A4-AB5F-01C3C588FE5A}"
      DTS:Description="Data Flow Task"
      DTS:DTSID="{40F5E4FD-1D69-424B-8505-7B68864F18DA}"
      DTS:ExecutableType="{5918251B-2970-45A4-AB5F-01C3C588FE5A}"
      DTS:LocaleID="-1"
      DTS:ObjectName="Import Data Into Stage Table">
      <DTS:Variables />
      <DTS:ObjectData>
        <pipeline
          version="1">
          <components>
            <component
              refId="Package\Import Data Into Stage Table\Derived Column"
              componentClassID="{49928E82-9C4E-49F0-AABE-3812B82707EC}"
              contactInfo="Derived Column;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"
              description="Creates new column values by applying expressions to transformation input columns. Create new columns or overwrite existing ones. For example, concatenate the values from the 'first name' and 'last name' column to make a 'full name' column."
              name="Derived Column"
              usesDispositions="true">
              <inputs>
                <input
                  refId="Package\Import Data Into Stage Table\Derived Column.Inputs[Derived Column Input]"
                  description="Input to the Derived Column Transformation"
                  name="Derived Column Input">
                  <externalMetadataColumns />
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output]"
                  description="Default Output of the Derived Column Transformation"
                  exclusionGroup="1"
                  name="Derived Column Output"
                  synchronousInputId="Package\Import Data Into Stage Table\Derived Column.Inputs[Derived Column Input]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output].Columns[BatchTag]"
                      dataType="wstr"
                      errorOrTruncationOperation="Computation"
                      errorRowDisposition="FailComponent"
                      length="20"
                      lineageId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output].Columns[BatchTag]"
                      name="BatchTag"
                      truncationRowDisposition="FailComponent">
                      <properties>
                        <property
                          containsID="true"
                          dataType="System.String"
                          description="Derived Column Expression"
                          name="Expression">(DT_WSTR,20)@[User::BatchTag]</property>
                        <property
                          containsID="true"
                          dataType="System.String"
                          description="Derived Column Friendly Expression"
                          expressionType="Notify"
                          name="FriendlyExpression">(DT_WSTR,20)@[User::BatchTag]</property>
                      </properties>
                    </outputColumn>
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output].Columns[ImportType]"
                      dataType="i4"
                      errorOrTruncationOperation="Computation"
                      errorRowDisposition="FailComponent"
                      lineageId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output].Columns[ImportType]"
                      name="ImportType"
                      truncationRowDisposition="FailComponent">
                      <properties>
                        <property
                          containsID="true"
                          dataType="System.String"
                          description="Derived Column Expression"
                          name="Expression">0</property>
                        <property
                          containsID="true"
                          dataType="System.String"
                          description="Derived Column Friendly Expression"
                          expressionType="Notify"
                          name="FriendlyExpression">0</property>
                      </properties>
                    </outputColumn>
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
                <output
                  refId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Error Output]"
                  description="Error Output of the Derived Column Transformation"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="Derived Column Error Output"
                  synchronousInputId="Package\Import Data Into Stage Table\Derived Column.Inputs[Derived Column Input]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Error Output].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\Import Data Into Stage Table\Excel Source"
              componentClassID="{8C084929-27D1-479F-9641-ABB7CDADF1AC}"
              contactInfo="Excel Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;1"
              description="Excel Source"
              name="Excel Source"
              usesDispositions="true"
              version="1">
              <properties>
                <property
                  dataType="System.Int32"
                  description="The number of seconds before a command times out.  A value of 0 indicates an infinite time-out."
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="Specifies the name of the database object used to open a rowset."
                  name="OpenRowset">Sheet1$</property>
                <property
                  dataType="System.String"
                  description="Specifies the variable that contains the name of the database object used to open a rowset."
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="The SQL command to be executed."
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
                <property
                  dataType="System.String"
                  description="The variable that contains the SQL command to be executed."
                  name="SqlCommandVariable"></property>
                <property
                  dataType="System.Int32"
                  description="Specifies the mode used to access the database."
                  name="AccessMode"
                  typeConverter="AccessMode">0</property>
                <property
                  dataType="System.String"
                  description="The mapping from parameters in the SQL command to variables."
                  name="ParameterMapping"></property>
              </properties>
              <connections>
                <connection
                  refId="Package\Import Data Into Stage Table\Excel Source.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[Excel Connection Manager]"
                  connectionManagerRefId="Package.ConnectionManagers[Excel Connection Manager]"
                  description="The OLE DB runtime connection used to access the database."
                  name="OleDbConnection" />
              </connections>
              <outputs>
                <output
                  refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output]"
                  name="Excel Source Output">
                  <outputColumns>
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].Columns[Product Category name]"
                      dataType="wstr"
                      errorOrTruncationOperation="Conversion"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].ExternalColumns[Product Category name]"
                      length="255"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].Columns[Product Category name]"
                      name="Product Category name"
                      truncationRowDisposition="FailComponent" />
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].Columns[Product Category ID]"
                      dataType="r8"
                      errorOrTruncationOperation="Conversion"
                      errorRowDisposition="FailComponent"
                      externalMetadataColumnId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].ExternalColumns[Product Category ID]"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].Columns[Product Category ID]"
                      name="Product Category ID"
                      truncationRowDisposition="FailComponent" />
                  </outputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].ExternalColumns[Product Category name]"
                      dataType="wstr"
                      length="255"
                      name="Product Category name" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].ExternalColumns[Product Category ID]"
                      dataType="r8"
                      name="Product Category ID" />
                  </externalMetadataColumns>
                </output>
                <output
                  refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output]"
                  isErrorOut="true"
                  name="Excel Source Error Output">
                  <outputColumns>
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[Product Category name]"
                      dataType="wstr"
                      length="255"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[Product Category name]"
                      name="Product Category name" />
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[Product Category ID]"
                      dataType="r8"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[Product Category ID]"
                      name="Product Category ID" />
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Error Output].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
            <component
              refId="Package\Import Data Into Stage Table\OLE DB Destination"
              componentClassID="{4ADA7EAA-136C-4215-8098-D7A7C27FC0D1}"
              contactInfo="OLE DB Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4"
              description="OLE DB Destination"
              name="OLE DB Destination"
              usesDispositions="true"
              version="4">
              <properties>
                <property
                  dataType="System.Int32"
                  description="The number of seconds before a command times out.  A value of 0 indicates an infinite time-out."
                  name="CommandTimeout">0</property>
                <property
                  dataType="System.String"
                  description="Specifies the name of the database object used to open a rowset."
                  name="OpenRowset">[stg].[Product_Category_Leaf]</property>
                <property
                  dataType="System.String"
                  description="Specifies the variable that contains the name of the database object used to open a rowset."
                  name="OpenRowsetVariable"></property>
                <property
                  dataType="System.String"
                  description="The SQL command to be executed."
                  name="SqlCommand"
                  UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"></property>
                <property
                  dataType="System.Int32"
                  description="Specifies the column code page to use when code page information is unavailable from the data source."
                  name="DefaultCodePage">1252</property>
                <property
                  dataType="System.Boolean"
                  description="Forces the use of the DefaultCodePage property value when describing character data."
                  name="AlwaysUseDefaultCodePage">false</property>
                <property
                  dataType="System.Int32"
                  description="Specifies the mode used to access the database."
                  name="AccessMode"
                  typeConverter="AccessMode">0</property>
                <property
                  dataType="System.Boolean"
                  description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on."
                  name="FastLoadKeepIdentity">false</property>
                <property
                  dataType="System.Boolean"
                  description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destination. Applies only if fast load is turned on."
                  name="FastLoadKeepNulls">false</property>
                <property
                  dataType="System.String"
                  description="Specifies options to be used with fast load.  Applies only if fast load is turned on."
                  name="FastLoadOptions"></property>
                <property
                  dataType="System.Int32"
                  description="Specifies when commits are issued during data insertion.  A value of 0 specifies that one commit will be issued at the end of data insertion.  Applies only if fast load is turned on."
                  name="FastLoadMaxInsertCommitSize">2147483647</property>
              </properties>
              <connections>
                <connection
                  refId="Package\Import Data Into Stage Table\OLE DB Destination.Connections[OleDbConnection]"
                  connectionManagerID="Package.ConnectionManagers[LocalHost.MDS]"
                  connectionManagerRefId="Package.ConnectionManagers[LocalHost.MDS]"
                  description="The OLE DB runtime connection used to access the database."
                  name="OleDbConnection" />
              </connections>
              <inputs>
                <input
                  refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input]"
                  errorOrTruncationOperation="Insert"
                  errorRowDisposition="FailComponent"
                  hasSideEffects="true"
                  name="OLE DB Destination Input">
                  <inputColumns>
                    <inputColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[BatchTag]"
                      cachedDataType="wstr"
                      cachedLength="20"
                      cachedName="BatchTag"
                      externalMetadataColumnId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[BatchTag]"
                      lineageId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output].Columns[BatchTag]" />
                    <inputColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ImportType]"
                      cachedDataType="i4"
                      cachedName="ImportType"
                      externalMetadataColumnId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ImportType]"
                      lineageId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output].Columns[ImportType]" />
                    <inputColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Product Category ID]"
                      cachedDataType="r8"
                      cachedName="Product Category ID"
                      externalMetadataColumnId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Code]"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].Columns[Product Category ID]" />
                    <inputColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Product Category name]"
                      cachedDataType="wstr"
                      cachedLength="255"
                      cachedName="Product Category name"
                      externalMetadataColumnId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Name]"
                      lineageId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output].Columns[Product Category name]" />
                  </inputColumns>
                  <externalMetadataColumns
                    isUsed="True">
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ID]"
                      dataType="i4"
                      name="ID" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ImportType]"
                      dataType="ui1"
                      name="ImportType" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ImportStatus_ID]"
                      dataType="ui1"
                      name="ImportStatus_ID" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Batch_ID]"
                      dataType="i4"
                      name="Batch_ID" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[BatchTag]"
                      dataType="wstr"
                      length="50"
                      name="BatchTag" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ErrorCode]"
                      dataType="i4"
                      name="ErrorCode" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Code]"
                      dataType="wstr"
                      length="250"
                      name="Code" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Name]"
                      dataType="wstr"
                      length="250"
                      name="Name" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[NewCode]"
                      dataType="wstr"
                      length="250"
                      name="NewCode" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ProductCategoryAlternateKey]"
                      dataType="numeric"
                      name="ProductCategoryAlternateKey"
                      precision="38" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[SpanishProductCategoryName]"
                      dataType="wstr"
                      length="100"
                      name="SpanishProductCategoryName" />
                    <externalMetadataColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[FrenchProductCategoryName]"
                      dataType="wstr"
                      length="100"
                      name="FrenchProductCategoryName" />
                  </externalMetadataColumns>
                </input>
              </inputs>
              <outputs>
                <output
                  refId="Package\Import Data Into Stage Table\OLE DB Destination.Outputs[OLE DB Destination Error Output]"
                  exclusionGroup="1"
                  isErrorOut="true"
                  name="OLE DB Destination Error Output"
                  synchronousInputId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input]">
                  <outputColumns>
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
                      dataType="i4"
                      lineageId="Package\Import Data Into Stage Table\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
                      name="ErrorCode"
                      specialFlags="1" />
                    <outputColumn
                      refId="Package\Import Data Into Stage Table\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
                      dataType="i4"
                      lineageId="Package\Import Data Into Stage Table\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
                      name="ErrorColumn"
                      specialFlags="2" />
                  </outputColumns>
                  <externalMetadataColumns />
                </output>
              </outputs>
            </component>
          </components>
          <paths>
            <path
              refId="Package\Import Data Into Stage Table.Paths[Derived Column Output]"
              endId="Package\Import Data Into Stage Table\OLE DB Destination.Inputs[OLE DB Destination Input]"
              name="Derived Column Output"
              startId="Package\Import Data Into Stage Table\Derived Column.Outputs[Derived Column Output]" />
            <path
              refId="Package\Import Data Into Stage Table.Paths[Excel Source Output]"
              endId="Package\Import Data Into Stage Table\Derived Column.Inputs[Derived Column Input]"
              name="Excel Source Output"
              startId="Package\Import Data Into Stage Table\Excel Source.Outputs[Excel Source Output]" />
          </paths>
        </pipeline>
      </DTS:ObjectData>
    </DTS:Executable>
    <DTS:Executable
      DTS:refId="Package\Run Batch"
      DTS:CreationName="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
      DTS:Description="Execute SQL Task"
      DTS:DTSID="{31E20A6E-D925-4415-AFBC-20693092F8C9}"
      DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
      DTS:LocaleID="-1"
      DTS:ObjectName="Run Batch"
      DTS:TaskContact="Execute SQL Task; Microsoft Corporation; SQL Server 2012; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:PropertyExpression
        DTS:Name="SqlStatementSource">"Exec [stg].[udp_Product_Category_Leaf] @VersionName=N'Version_1',@LogFlag=1,@BatchTag=N'"+@[User::BatchTag]+"'"</DTS:PropertyExpression>
      <DTS:ObjectData>
        <SQLTask:SqlTaskData
          SQLTask:Connection="{604A6D7D-BD7D-4336-AB92-FB79168E1DCC}"
          SQLTask:SqlStatementSource="Exec [stg].[udp_Product_Category_Leaf] @VersionName=N'Version_1',@LogFlag=1,@BatchTag=N''" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask" />
      </DTS:ObjectData>
    </DTS:Executable>
    <DTS:Executable
      DTS:refId="Package\Set Batch Tag"
      DTS:CreationName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTask, Microsoft.SqlServer.ExpressionTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
      DTS:Description="Expression Task"
      DTS:DTSID="{E15318F7-0B82-450D-8BA8-880585CA32EC}"
      DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTask, Microsoft.SqlServer.ExpressionTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
      DTS:LocaleID="-1"
      DTS:ObjectName="Set Batch Tag"
      DTS:TaskContact="Expression Task;Microsoft Corporation; SQL Server 2012; � 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1"
      DTS:ThreadHint="0">
      <DTS:Variables />
      <DTS:ObjectData>
        <ExpressionTask
          Expression="@[User::BatchTag] =&quot;Product Category_&quot;+&#xA; (DT_WSTR, 4) DATEPART(&quot;yy&quot;, GETDATE()  )+&#xA;RIGHT( &quot;0&quot;+(DT_WSTR, 4) DATEPART(&quot;mm&quot;, GETDATE()  ),2)+&#xA;RIGHT(&quot;0&quot;+ (DT_WSTR, 4) DATEPART(&quot;dd&quot;, GETDATE()  ),2)" />
      </DTS:ObjectData>
    </DTS:Executable>
  </DTS:Executables>
  <DTS:PrecedenceConstraints>
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint]"
      DTS:CreationName=""
      DTS:DTSID="{DEFCEC80-50FE-46EC-AA70-FC1036E3E9A0}"
      DTS:From="Package\Set Batch Tag"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint"
      DTS:To="Package\Import Data Into Stage Table" />
    <DTS:PrecedenceConstraint
      DTS:refId="Package.PrecedenceConstraints[Constraint 1]"
      DTS:CreationName=""
      DTS:DTSID="{66029018-FFE6-4603-A275-6F93EDD9B667}"
      DTS:From="Package\Import Data Into Stage Table"
      DTS:LogicalAnd="True"
      DTS:ObjectName="Constraint 1"
      DTS:To="Package\Run Batch" />
  </DTS:PrecedenceConstraints>
  <DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>
<!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.-->
<!--If you manually edit this section and make a mistake, you can delete it. -->
<!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.-->
<Objects
  Version="sql11">
  <!--Each node below will contain properties that do not affect runtime behavior.-->
  <Package
    design-time-name="Package">
    <LayoutInfo>
      <GraphLayout
        Capacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
        <NodeLayout
          Size="218,42"
          Id="Package\Import Data Into Stage Table"
          TopLeft="111.5,168.5" />
        <NodeLayout
          Size="145,42"
          Id="Package\Set Batch Tag"
          TopLeft="154,58" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint]"
          TopLeft="223.5,100">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,68.5"
              Start="0,0"
              End="0,61">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,61" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <NodeLayout
          Size="127,42"
          Id="Package\Run Batch"
          TopLeft="157,271" />
        <EdgeLayout
          Id="Package.PrecedenceConstraints[Constraint 1]"
          TopLeft="220.5,210.5">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,60.5"
              Start="0,0"
              End="0,53">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,53" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </Package>
  <TaskHost
    design-time-name="Package\Import Data Into Stage Table">
    <LayoutInfo>
      <GraphLayout
        Capacity="8" xmlns="clr-namespace:Microsoft.SqlServer.IntegrationServices.Designer.Model.Serialization;assembly=Microsoft.SqlServer.IntegrationServices.Graph" xmlns:mssgle="clr-namespace:Microsoft.SqlServer.Graph.LayoutEngine;assembly=Microsoft.SqlServer.Graph" xmlns:assembly="http://schemas.microsoft.com/winfx/2006/xaml">
        <NodeLayout
          Size="139,42"
          Id="Package\Import Data Into Stage Table\Excel Source"
          TopLeft="158,53" />
        <NodeLayout
          Size="171,42"
          Id="Package\Import Data Into Stage Table\OLE DB Destination"
          TopLeft="142,216" />
        <NodeLayout
          Size="154,42"
          Id="Package\Import Data Into Stage Table\Derived Column"
          TopLeft="152,142" />
        <EdgeLayout
          Id="Package\Import Data Into Stage Table.Paths[Excel Source Output]"
          TopLeft="228.25,95">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,47"
              Start="0,0"
              End="0,39.5">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,39.5" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <EdgeLayout
          Id="Package\Import Data Into Stage Table.Paths[Derived Column Output]"
          TopLeft="228.25,184">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,32"
              Start="0,0"
              End="0,24.5">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,24.5" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
      </GraphLayout>
    </LayoutInfo>
  </TaskHost>
  <PipelineComponentMetadata
    design-time-name="Package\Import Data Into Stage Table\Excel Source">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
  <PipelineComponentMetadata
    design-time-name="Package\Import Data Into Stage Table\OLE DB Destination">
    <Properties>
      <Property>
        <Name>DataSourceViewID</Name>
      </Property>
      <Property>
        <Name>TableInfoObjectType</Name>
        <Value
          type="q2:string">Table</Value>
      </Property>
    </Properties>
  </PipelineComponentMetadata>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>