<?xml version="1.0" encoding="utf-8"?>
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <DeploymentModel>Project</DeploymentModel>
  <ProductVersion>11.0.3360.12</ProductVersion>
  <SchemaVersion>9.0.1.0</SchemaVersion>
  <State>$base64$PFNvdXJjZUNvbnRyb2xJbmZvIHhtbG5zOnhzZD0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEiIHhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEtaW5zdGFuY2UiIHhtbG5zOmRkbDI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yIiB4bWxuczpkZGwyXzI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yLzIiIHhtbG5zOmRkbDEwMF8xMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDA4L2VuZ2luZS8xMDAvMTAwIiB4bWxuczpkZGwyMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAiIHhtbG5zOmRkbDIwMF8yMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAvMjAwIiB4bWxuczpkZGwzMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAiIHhtbG5zOmRkbDMwMF8zMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAvMzAwIiB4bWxuczpkZGw0MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAiIHhtbG5zOmRkbDQwMF80MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAvNDAwIiB4bWxuczpkd2Q9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vRGF0YVdhcmVob3VzZS9EZXNpZ25lci8xLjAiPg0KICA8RW5hYmxlZD5mYWxzZTwvRW5hYmxlZD4NCiAgPFByb2plY3ROYW1lPjwvUHJvamVjdE5hbWU+DQogIDxBdXhQYXRoPjwvQXV4UGF0aD4NCiAgPExvY2FsUGF0aD48L0xvY2FsUGF0aD4NCiAgPFByb3ZpZGVyPjwvUHJvdmlkZXI+DQo8L1NvdXJjZUNvbnRyb2xJbmZvPg==</State>
  <Database>
    <Name>Entity Based Staging.database</Name>
    <FullPath>Entity Based Staging.database</FullPath>
  </Database>
  <DataSources />
  <DataSourceViews />
  <DeploymentModelSpecificContent>
    <Manifest>
      <SSIS:Project SSIS:ProtectionLevel="EncryptSensitiveWithUserKey" xmlns:SSIS="www.microsoft.com/SqlServer/SSIS">
        <SSIS:Properties>
          <SSIS:Property SSIS:Name="ID">{59a83c72-2fc9-4e4e-9d2a-a74a146de3c7}</SSIS:Property>
          <SSIS:Property SSIS:Name="Name">Entity Based Staging</SSIS:Property>
          <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
          <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
          <SSIS:Property SSIS:Name="VersionBuild">0</SSIS:Property>
          <SSIS:Property SSIS:Name="VersionComments">
          </SSIS:Property>
          <SSIS:Property SSIS:Name="CreationDate">2013-05-05T18:08:14.6807918+12:00</SSIS:Property>
          <SSIS:Property SSIS:Name="CreatorName">REZA-VAIO\Reza</SSIS:Property>
          <SSIS:Property SSIS:Name="CreatorComputerName">REZA-VAIO</SSIS:Property>
          <SSIS:Property SSIS:Name="Description">
          </SSIS:Property>
          <SSIS:Property SSIS:Name="PasswordVerifier" SSIS:Sensitive="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAA64LOhdTxtkiCpp/ucz2YdAAAAAACAAAAAAAQZgAAAAEAACAAAAAcnzC1Lvapwb+LwLYDW62sCD/5Kpm0B9+hLd9QMyOAMwAAAAAOgAAAAAIAACAAAAAQzEwI7AuMfa/fe7aeZWAEOcAoYaOUqY5/vEgxt10s7ZAAAACY3QpbF9M6LPu3McDmywXpTpxqsPU1EycNKh9wu0wlSPGt2t3Wb2o2mogQv1pg3E+151cPNTaITi5PSOEAPrQyCMw10wcG285u0/Ur+whEbKFTD4R3g6YzCWwcUS0U94DoI6PB6dx2JLaCLvuogspshSZJzBd/9V27i34REP88y2oh1E/9aiDy1onXwEYBCh5AAAAA8HdVmZgkBJOoPpHm5bH0nnnQTiW+ss8CtfVZm8mte3wM2o7yAQyPqQbzOkEAsKUsp3YVQMkIOv6ns1itdEOfqQ==</SSIS:Property>
          <SSIS:Property SSIS:Name="FormatVersion">1</SSIS:Property>
        </SSIS:Properties>
        <SSIS:Packages>
          <SSIS:Package SSIS:Name="Package.dtsx" SSIS:EntryPoint="1" />
        </SSIS:Packages>
        <SSIS:ConnectionManagers />
        <SSIS:DeploymentInfo>
          <SSIS:ProjectConnectionParameters />
          <SSIS:PackageInfo>
            <SSIS:PackageMetaData SSIS:Name="Package.dtsx">
              <SSIS:Properties>
                <SSIS:Property SSIS:Name="ID">{8FA7D124-E3A7-4447-AEE5-70BDC2928BF9}</SSIS:Property>
                <SSIS:Property SSIS:Name="Name">Package</SSIS:Property>
                <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
                <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
                <SSIS:Property SSIS:Name="VersionBuild">2</SSIS:Property>
                <SSIS:Property SSIS:Name="VersionComments">
                </SSIS:Property>
                <SSIS:Property SSIS:Name="VersionGUID">{71EABA5C-5728-4727-A664-0E8F377CB512}</SSIS:Property>
                <SSIS:Property SSIS:Name="PackageFormatVersion">6</SSIS:Property>
                <SSIS:Property SSIS:Name="Description">
                </SSIS:Property>
                <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
              </SSIS:Properties>
              <SSIS:Parameters>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.ConnectionString">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">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="Excel 12.0 XML;HDR=YES";</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.ExcelFilePath">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">C:\Dropbox\Reza\Dropbox\PACKTPUB_SHARE\05_CHAPTERS\Chapter 05\Source Code\Product Categories.xlsx</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.FirstRowHasColumnName">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">true</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.InitialCatalog">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.Password">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.RetainSameConnection">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.ServerName">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">C:\Dropbox\Reza\Dropbox\PACKTPUB_SHARE\05_CHAPTERS\Chapter 05\Source Code\Product Categories.xlsx</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.Excel Connection Manager.UserName">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.LocalHost.MDS.ConnectionString">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">Data Source=.;Initial Catalog=MDS;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.LocalHost.MDS.InitialCatalog">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">MDS</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.LocalHost.MDS.Password">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.LocalHost.MDS.RetainSameConnection">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.LocalHost.MDS.ServerName">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Value">.</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
                <SSIS:Parameter SSIS:Name="CM.LocalHost.MDS.UserName">
                  <SSIS:Properties>
                    <SSIS:Property SSIS:Name="ID">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="CreationName">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="Description">
                    </SSIS:Property>
                    <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
                    <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
                  </SSIS:Properties>
                </SSIS:Parameter>
              </SSIS:Parameters>
            </SSIS:PackageMetaData>
          </SSIS:PackageInfo>
        </SSIS:DeploymentInfo>
      </SSIS:Project>
    </Manifest>
  </DeploymentModelSpecificContent>
  <Miscellaneous />
  <Configurations>
    <Configuration>
      <Name>Development</Name>
      <Options>
        <OutputPath>bin</OutputPath>
        <ConnectionMappings />
        <ConnectionProviderMappings />
        <ConnectionSecurityMappings />
        <DatabaseStorageLocations />
        <ParameterConfigurationValues>
          <ConfigurationSetting>
            <Id>LastModifiedTime</Id>
            <Name>LastModifiedTime</Name>
            <Value xsi:type="xsd:dateTime">2013-05-05T06:31:07.8394255Z</Value>
          </ConfigurationSetting>
        </ParameterConfigurationValues>
      </Options>
    </Configuration>
  </Configurations>
</Project>