mdwt_adventureworks_ssis.dtproj

数据仓库开发的很好的一个例子

<?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">
  <ProductVersion>9.0.3042.0</ProductVersion>
  <SchemaVersion>9.0.1.0</SchemaVersion>
  <State>$base64$PFNvdXJjZUNvbnRyb2xJbmZvIHhtbG5zOnhzZD0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEiIHhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEtaW5zdGFuY2UiIHhtbG5zOmRkbDI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yIiB4bWxuczpkZGwyXzI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yLzIiIHhtbG5zOmR3ZD0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9EYXRhV2FyZWhvdXNlL0Rlc2lnbmVyLzEuMCI+DQogIDxFbmFibGVkPmZhbHNlPC9FbmFibGVkPg0KICA8UHJvamVjdE5hbWU+PC9Qcm9qZWN0TmFtZT4NCiAgPEF1eFBhdGg+PC9BdXhQYXRoPg0KICA8TG9jYWxQYXRoPjwvTG9jYWxQYXRoPg0KICA8UHJvdmlkZXI+PC9Qcm92aWRlcj4NCjwvU291cmNlQ29udHJvbEluZm8+</State>
  <Database>
    <Name>MDWT_AdventureWorks_SSIS.database</Name>
    <FullPath>MDWT_AdventureWorks_SSIS.database</FullPath>
  </Database>
  <Cubes />
  <Dimensions />
  <DataSources>
    <ProjectItem>
      <Name>AdventureWorks.ds</Name>
      <FullPath>AdventureWorks.ds</FullPath>
    </ProjectItem>
    <ProjectItem>
      <Name>MDWT AdventureWorksDW OLEDB.ds</Name>
      <FullPath>MDWT AdventureWorksDW OLEDB.ds</FullPath>
    </ProjectItem>
    <ProjectItem>
      <Name>MDWT AdventureWorksDW dotNet.ds</Name>
      <FullPath>MDWT AdventureWorksDW dotNet.ds</FullPath>
    </ProjectItem>
  </DataSources>
  <DataSourceViews>
    <ProjectItem>
      <Name>AdventureWorks Source.dsv</Name>
      <FullPath>AdventureWorks Source.dsv</FullPath>
    </ProjectItem>
  </DataSourceViews>
  <MiningModels />
  <Roles />
  <Miscellaneous>
    <ProjectItem>
      <Name>ReadMe.doc</Name>
      <FullPath>ReadMe.doc</FullPath>
    </ProjectItem>
    <ProjectItem>
      <Name>cr_MDWT_AdventureWorksDW.sql</Name>
      <FullPath>cr_MDWT_AdventureWorksDW.sql</FullPath>
    </ProjectItem>
  </Miscellaneous>
  <Configurations>
    <Configuration>
      <Name>Development</Name>
      <Options>
        <OutputPath>bin</OutputPath>
        <ConnectionMappings>
          <ConfigurationSetting>
            <Id>MDWT AdventureWorksDW</Id>
            <Name>MDWT AdventureWorksDW</Name>
            <Value xsi:type="xsd:string">Data Source=.;Initial Catalog=MDWT_AdventureWorksDW;Integrated Security=True</Value>
          </ConfigurationSetting>
          <ConfigurationSetting>
            <Id>AdventureWorks</Id>
            <Name>AdventureWorks</Name>
            <Value xsi:type="xsd:string">Provider=SQLNCLI.1;Data Source=.;Integrated Security=SSPI;Initial Catalog=AdventureWorks</Value>
          </ConfigurationSetting>
          <ConfigurationSetting>
            <Id>MDWT AdventureWorksDW OLEDB</Id>
            <Name>MDWT AdventureWorksDW OLEDB</Name>
            <Value xsi:type="xsd:string">Provider=SQLNCLI.1;Data Source=.;Integrated Security=SSPI;Initial Catalog=MDWT_AdventureWorksDW</Value>
          </ConfigurationSetting>
        </ConnectionMappings>
        <ConnectionProviderMappings>
          <ConfigurationSetting>
            <Id>MDWT AdventureWorksDW</Id>
            <Name>MDWT AdventureWorksDW</Name>
            <Value xsi:type="xsd:string">System.Data.SqlClient</Value>
          </ConfigurationSetting>
        </ConnectionProviderMappings>
        <ConnectionSecurityMappings>
          <ConfigurationSetting>
            <Id>MDWT AdventureWorksDW</Id>
            <Name>MDWT AdventureWorksDW</Name>
            <Value xsi:type="xsd:int">0</Value>
          </ConfigurationSetting>
          <ConfigurationSetting>
            <Id>AdventureWorks</Id>
            <Name>AdventureWorks</Name>
            <Value xsi:type="xsd:int">0</Value>
          </ConfigurationSetting>
          <ConfigurationSetting>
            <Id>MDWT AdventureWorksDW OLEDB</Id>
            <Name>MDWT AdventureWorksDW OLEDB</Name>
            <Value xsi:type="xsd:int">0</Value>
          </ConfigurationSetting>
        </ConnectionSecurityMappings>
      </Options>
    </Configuration>
  </Configurations>
  <DTSPackages>
    <DtsPackage>
      <Name>RUN THIS TO LOAD ALL.dtsx</Name>
      <FullPath>RUN THIS TO LOAD ALL.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimCurrency.dtsx</Name>
      <FullPath>DimCurrency.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimCustomer.dtsx</Name>
      <FullPath>DimCustomer.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimDate.dtsx</Name>
      <FullPath>DimDate.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimEmployee.dtsx</Name>
      <FullPath>DimEmployee.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimOrderInfo.dtsx</Name>
      <FullPath>DimOrderInfo.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimProduct.dtsx</Name>
      <FullPath>DimProduct.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>DimPromotion.dtsx</Name>
      <FullPath>DimPromotion.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>FactExchangeRates.dtsx</Name>
      <FullPath>FactExchangeRates.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>FactOrders.dtsx</Name>
      <FullPath>FactOrders.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>Master_Dims.dtsx</Name>
      <FullPath>Master_Dims.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>Master_Facts.dtsx</Name>
      <FullPath>Master_Facts.dtsx</FullPath>
      <References />
    </DtsPackage>
    <DtsPackage>
      <Name>RUN FIRST AND ONLY ONCE.dtsx</Name>
      <FullPath>RUN FIRST AND ONLY ONCE.dtsx</FullPath>
      <References />
    </DtsPackage>
  </DTSPackages>
</Project>