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

ArunRaaman 991 Reputation points
2021-05-18T19:47:03.91+00:00

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
    2021-05-19T01:40:25.373+00:00

    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.

    adventureworks-install-configure

    And then it should work fine.

    97752-screenshot-2021-05-19-093157.jpg
    97697-screenshot-2021-05-19-093358.jpg

    Regards,

    Zoe


    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