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

Question

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

Answer 1

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.

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