<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
  DTS:refId="Package"
  DTS:CreationDate="7/30/2013 7:43:40 PM"
  DTS:CreationName="SSIS.Package.3"
  DTS:CreatorComputerName="REZA-VAIO"
  DTS:CreatorName="REZA-VAIO\Reza"
  DTS:DTSID="{73D27017-877A-4EA7-9079-F7BD20D2DDF0}"
  DTS:ExecutableType="SSIS.Package.3"
  DTS:LastModifiedProductVersion="11.0.3360.12"
  DTS:LocaleID="1033"
  DTS:ObjectName="Master Package"
  DTS:PackageType="5"
  DTS:VersionBuild="9"
  DTS:VersionGUID="{10BCB217-68E6-435D-825D-BA2FE8B11770}">
  <DTS:Property
    DTS:Name="PackageFormatVersion">6</DTS:Property>
  <DTS:ConnectionManagers>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[Archive]"
      DTS:CreationName="FILE"
      DTS:DTSID="{8A63B7C5-2948-4142-8027-4A7F1CC9293F}"
      DTS:ObjectName="Archive">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:FileUsageType="2"
          DTS:ConnectionString="C:\Dropbox\Reza\Dropbox\PacktPub_Microsoft Business Intelligence with SQL Server 2012\05_CHAPTERS\Chapter 04\Source Code\Files\Archive" />
      </DTS:ObjectData>
    </DTS:ConnectionManager>
    <DTS:ConnectionManager
      DTS:refId="Package.ConnectionManagers[Flat File Connection Manager]"
      DTS:CreationName="FLATFILE"
      DTS:DTSID="{875BEE55-CA25-4D4E-B553-7EBE3EDD3A91}"
      DTS:ObjectName="Flat File Connection Manager">
      <DTS:ObjectData>
        <DTS:ConnectionManager
          DTS:Format="Delimited"
          DTS:LocaleID="1033"
          DTS:HeaderRowDelimiter="_x000D__x000A_"
          DTS:ColumnNamesInFirstDataRow="True"
          DTS:RowDelimiter=""
          DTS:TextQualifier="_x0022_"
          DTS:CodePage="1252"
          DTS:ConnectionString="C:\Dropbox\Reza\Dropbox\PacktPub_Microsoft Business Intelligence with SQL Server 2012\05_CHAPTERS\Chapter 04\Source Code\Files\Source\Customers_2.csv">
          <DTS:FlatFileColumns>
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="CustomerKey"
              DTS:DTSID="{C819DC75-774D-4BE6-97D6-9EDC89EF384D}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="GeographyKey"
              DTS:DTSID="{355B7FD4-4A45-4291-BFAC-813A792B9472}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="CustomerAlternateKey"
              DTS:DTSID="{604D23FA-E6CA-4A46-A7BB-1B902AFD7B2A}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="Title"
              DTS:DTSID="{60CAD3BA-08B4-4E14-A82D-4D6E3550D173}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="FirstName"
              DTS:DTSID="{D80A7B62-D51E-41C9-9DA5-87AF12DCD917}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="MiddleName"
              DTS:DTSID="{B2256AAB-EE40-4A3D-B2A3-284FBEF14343}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="LastName"
              DTS:DTSID="{165303CB-B6F0-4625-9AF5-2CF7E5C8CFE7}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="NameStyle"
              DTS:DTSID="{4F1FE704-AB47-46E8-8049-17054F01283E}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="BirthDate"
              DTS:DTSID="{239D5E0A-83CF-46E9-A6D0-5EF14D8EED9A}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="MaritalStatus"
              DTS:DTSID="{B98DAAE6-C718-48C7-8C3B-2B84311C203A}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="Suffix"
              DTS:DTSID="{3D9A743D-00D8-4EF8-83C8-145F9F4EC132}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="Gender"
              DTS:DTSID="{3CAB17BE-01F1-4C5E-AC41-CE460223B413}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="EmailAddress"
              DTS:DTSID="{51BC4248-9C1C-4D88-859A-6A59A8AC7935}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="YearlyIncome"
              DTS:DTSID="{E58F3D4A-7A75-4344-9656-4D6C4E323157}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="TotalChildren"
              DTS:DTSID="{52A9BC47-9886-440E-A81F-F8F4B83DF336}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="NumberChildrenAtHome"
              DTS:DTSID="{66D2E504-AE5F-4443-A4DD-562FEBDAE35A}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="EnglishEducation"
              DTS:DTSID="{4401C2AE-4A50-42DB-8A8F-4DD6A5A1A95B}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="SpanishEducation"
              DTS:DTSID="{E71AAB45-0653-4DE1-9140-07D44CA90698}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="FrenchEducation"
              DTS:DTSID="{D87DD4F8-63AD-44CE-A9AD-4F4D08165943}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="EnglishOccupation"
              DTS:DTSID="{766AF45D-16C5-4802-9C9B-CD0B00E6F2F6}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="SpanishOccupation"
              DTS:DTSID="{762FA4DE-E67D-45D7-95F6-66CA40E6DFB0}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="FrenchOccupation"
              DTS:DTSID="{23764C15-F146-4708-92A6-BCAD5A4C55FF}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="HouseOwnerFlag"
              DTS:DTSID="{6792024D-297D-41AE-AAFC-9A65684FEBD1}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="NumberCarsOwned"
              DTS:DTSID="{A712AB19-C93A-4DCB-9D99-CB6FFC7FBA3B}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="AddressLine1"
              DTS:DTSID="{5F4A1431-36B0-4906-902B-278B5D7ED555}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="AddressLine2"
              DTS:DTSID="{E5ED766E-F612-4B4F-B7E5-CE6CA013166F}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="Phone"
              DTS:DTSID="{1ECE6020-E86A-4012-B4C9-24464EA5069A}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x002C_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="DateFirstPurchase"
              DTS:DTSID="{65054931-F92A-4D28-A7DE-5684912B74CA}"
              DTS:CreationName="" />
            <DTS:FlatFileColumn
              DTS:ColumnType="Delimited"
              DTS:ColumnDelimiter="_x000D__x000A_"
              DTS:MaximumWidth="50"
              DTS:DataType="129"
              DTS:TextQualified="True"
              DTS:ObjectName="CommuteDistance"
              DTS:DTSID="{48B4820C-E9B8-45EB-B4BE-277DBB187C78}"
              DTS:CreationName="" />
          </DTS:FlatFileColumns>
        </DTS:ConnectionManager>
      </DTS:ObjectData>
    </DTS:ConnectionManager>
  </DTS:ConnectionManagers>
  <DTS:Variables>
    <DTS:Variable
      DTS:CreationName=""
      DTS:DTSID="{C63DB3B1-9F53-447F-8054-B0E6657B63BC}"
      DTS:IncludeInDebugDump="2345"
      DTS:Namespace="User"
      DTS:ObjectName="FilePath">
      <DTS:VariableValue
        DTS:DataType="8">C:\Dropbox\Reza\Dropbox\PacktPub_Microsoft Business Intelligence with SQL Server 2012\05_CHAPTERS\Chapter 04\Source Code\Files\Source\Customers_1.csv</DTS:VariableValue>
    </DTS:Variable>
  </DTS:Variables>
  <DTS:Executables>
    <DTS:Executable
      DTS:refId="Package\Foreach Loop Container"
      DTS:CreationName="STOCK:FOREACHLOOP"
      DTS:Description="Foreach Loop Container"
      DTS:DTSID="{463B0E64-A474-40CE-9D2B-B98D81C72E66}"
      DTS:ExecutableType="STOCK:FOREACHLOOP"
      DTS:LocaleID="-1"
      DTS:ObjectName="Foreach Loop Container">
      <DTS:ForEachEnumerator
        DTS:CreationName="DTS.ForEachFileEnumerator.3"
        DTS:DTSID="{E89E1B64-2DB9-4F3D-A68C-FE4C88352B19}"
        DTS:ObjectName="{E89E1B64-2DB9-4F3D-A68C-FE4C88352B19}">
        <DTS:ObjectData>
          <ForEachFileEnumeratorProperties>
            <FEFEProperty
              Folder="C:\Dropbox\Reza\Dropbox\PacktPub_Microsoft Business Intelligence with SQL Server 2012\05_CHAPTERS\Chapter 04\Source Code\Files\Source" />
            <FEFEProperty
              FileSpec="*.*" />
            <FEFEProperty
              FileNameRetrievalType="0" />
            <FEFEProperty
              Recurse="0" />
          </ForEachFileEnumeratorProperties>
        </DTS:ObjectData>
      </DTS:ForEachEnumerator>
      <DTS:Variables />
      <DTS:Executables>
        <DTS:Executable
          DTS:refId="Package\Foreach Loop Container\Archive Customer File"
          DTS:CreationName="SSIS.ExecutePackageTask.3"
          DTS:Description="Execute Package Task"
          DTS:DTSID="{FF9B44C6-9CBB-40DD-9103-F2B66024C625}"
          DTS:ExecutableType="SSIS.ExecutePackageTask.3"
          DTS:LocaleID="-1"
          DTS:ObjectName="Archive Customer File"
          DTS:TaskContact="Microsoft Corporation; Microsoft SQL Server; Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
          <DTS:Variables />
          <DTS:ObjectData>
            <ExecutePackageTask>
              <UseProjectReference>True</UseProjectReference>
              <PackageName>Archive Customer File - Parametrized.dtsx</PackageName>
              <ParameterAssignment>
                <ParameterName>SourceFilePath</ParameterName>
                <BindedVariableOrParameterName>User::FilePath</BindedVariableOrParameterName>
              </ParameterAssignment>
            </ExecutePackageTask>
          </DTS:ObjectData>
        </DTS:Executable>
        <DTS:Executable
          DTS:refId="Package\Foreach Loop Container\Transfer Customer Data"
          DTS:CreationName="SSIS.ExecutePackageTask.3"
          DTS:Description="Execute Package Task"
          DTS:DTSID="{2B76CDB2-F0C2-4E57-971E-A816F0CDB48E}"
          DTS:ExecutableType="SSIS.ExecutePackageTask.3"
          DTS:LocaleID="-1"
          DTS:ObjectName="Transfer Customer Data"
          DTS:TaskContact="Microsoft Corporation; Microsoft SQL Server; Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
          <DTS:Variables />
          <DTS:ObjectData>
            <ExecutePackageTask>
              <UseProjectReference>True</UseProjectReference>
              <PackageName>Transfer Customer Data - Parametrized.dtsx</PackageName>
              <ParameterAssignment>
                <ParameterName>FlatFileConnectionManager_ConnectionString</ParameterName>
                <BindedVariableOrParameterName>User::FilePath</BindedVariableOrParameterName>
              </ParameterAssignment>
            </ExecutePackageTask>
          </DTS:ObjectData>
        </DTS:Executable>
      </DTS:Executables>
      <DTS:PrecedenceConstraints>
        <DTS:PrecedenceConstraint
          DTS:refId="Package\Foreach Loop Container.PrecedenceConstraints[Constraint]"
          DTS:CreationName=""
          DTS:DTSID="{CB6057A8-84B2-4F89-B59F-AD728687D7B7}"
          DTS:From="Package\Foreach Loop Container\Transfer Customer Data"
          DTS:LogicalAnd="True"
          DTS:ObjectName="Constraint"
          DTS:To="Package\Foreach Loop Container\Archive Customer File" />
      </DTS:PrecedenceConstraints>
      <DTS:ForEachVariableMappings>
        <DTS:ForEachVariableMapping
          DTS:CreationName=""
          DTS:DTSID="{0141D64A-D2AA-44B5-9950-C58412C49314}"
          DTS:ObjectName="{0141D64A-D2AA-44B5-9950-C58412C49314}"
          DTS:ValueIndex="0"
          DTS:VariableName="User::FilePath" />
      </DTS:ForEachVariableMappings>
    </DTS:Executable>
  </DTS:Executables>
  <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="4" 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="192,42"
          Id="Package\Foreach Loop Container\Transfer Customer Data"
          TopLeft="47,30" />
        <NodeLayout
          Size="181,42"
          Id="Package\Foreach Loop Container\Archive Customer File"
          TopLeft="55,128" />
        <EdgeLayout
          Id="Package\Foreach Loop Container.PrecedenceConstraints[Constraint]"
          TopLeft="144.25,72">
          <EdgeLayout.Curve>
            <mssgle:Curve
              StartConnector="{assembly:Null}"
              EndConnector="0,56"
              Start="0,0"
              End="0,48.5">
              <mssgle:Curve.Segments>
                <mssgle:SegmentCollection
                  Capacity="5">
                  <mssgle:LineSegment
                    End="0,48.5" />
                </mssgle:SegmentCollection>
              </mssgle:Curve.Segments>
            </mssgle:Curve>
          </EdgeLayout.Curve>
          <EdgeLayout.Labels>
            <EdgeLabelCollection />
          </EdgeLayout.Labels>
        </EdgeLayout>
        <ContainerLayout
          HeaderHeight="43"
          IsExpanded="True"
          PanelSize="266,202"
          Size="266,245"
          Id="Package\Foreach Loop Container"
          TopLeft="146,108" />
      </GraphLayout>
    </LayoutInfo>
  </Package>
</Objects>]]></DTS:DesignTimeProperties>
</DTS:Executable>