question

ArunRaaman-6281 avatar image
0 Votes"
ArunRaaman-6281 asked ArunRaaman-6281 commented

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

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks, Zoehui for your help!

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @ArunRaaman-6281,

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.