about the SQL code in SSIS-Tutorial-Lesson-1-6

ArunRaaman 991 Reputation points

Hello There,
I recently started practicing SSIS-tutorial, and am in Tutorial -- Lesson 1-6; While executing the steps in the document, under the Heading "Add and configure the Lookup Currency Key transformation" I couldn't find

'Sales.Currency' table in AdventureWorksDW2012 as per the following query:

SELECT * FROM [Sales].[Currency]
WHERE [CurrencyCode]
IN ('ARS', 'AUD', 'BRL', 'CAD', 'CNY',
'DEM', 'EUR', 'FRF', 'GBP', 'JPY',
'MXN', 'SAR', 'USD', 'VEB')

Would anyone help me locate the issue?

Thank you

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,404 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 30,261 Reputation points

    Hi @ArunRaaman ,

    Please edit the code with below:

      SELECT * FROM  [AdventureWorksDW2012].[dbo].[DimCurrency]  
    WHERE [CurrencyAlternateKey]  
    IN ('ARS', 'AUD', 'BRL', 'CAD', 'CNY',  
        'DEM', 'EUR', 'FRF', 'GBP', 'JPY',  
        'MXN', 'SAR', 'USD', 'VEB')  

    Also you may use the OLTP AdventureWorks2012 database for train.


    And then it should work fine.




    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

0 additional answers

Sort by: Most helpful