尝试学习SSIS教程:为SQL Server 2012创建简单ETL包

Question

我正试图通过此示例创建SSIS包，但查询在步骤6中不起作用，而且此数据库中似乎没有"dbo.dimcurrency"表。我在执行查询时遇到以下错误。。消息208，级别16，状态1，第2行对象名称"dbo.DimCurrency"无效。

https://msdn.microsoft.com/en-us/library/5c59f723-9707-4407-80ae-f05f483cf65f（v=sql.110）

<code> use AdventureWorks2012;
 Select * from (select * from [dbo].[DimCurrency]) as refTable
where [refTable].[CurrencyAlternateKey] = 'ARS'
OR
[refTable].[CurrencyAlternateKey] = 'AUD'
OR
[refTable].[CurrencyAlternateKey] = 'BRL'
OR
[refTable].[CurrencyAlternateKey] = 'CAD'
OR
[refTable].[CurrencyAlternateKey] = 'CNY'
OR
[refTable].[CurrencyAlternateKey] = 'DEM'
OR
[refTable].[CurrencyAlternateKey] = 'EUR'
OR
[refTable].[CurrencyAlternateKey] = 'FRF'
OR
[refTable].[CurrencyAlternateKey] = 'GBP'
OR
[refTable].[CurrencyAlternateKey] = 'JPY'
OR
[refTable].[CurrencyAlternateKey] = 'MXN'
OR
[refTable].[CurrencyAlternateKey] = 'SAR'
OR
[refTable].[CurrencyAlternateKey] = 'USD'
OR
[refTable].[CurrencyAlternateKey] = 'VEB'
</code>

Answer 1

您需要安装AdventureWorksDW2012数据库才能完成本教程。您正在尝试读取不存在的表[dbo].[DimCurrency]。请参阅此处的要求。

更新：

您可以创建[dbo]。[DimCurrency]表使用以下SQL，这应该可以消除您的错误（尽管该表显然是空的）：

USE AdventureWorks2012
CREATE TABLE [dbo].[DimCurrency]
      (
        [CurrencyAlternateKey] nchar(3) NOT NULL,
        [CurrencyKey] int NOT NULL,
        [CurrencyName] nvarchar(50) NOT NULL
      );