DTS multiple rows from multiple tables 1

[jigen3]

hi,
i have two tables: table A has city names and the country they belong to, table B has the country and its currency. is there a way i can output the city from table A, and the currency used in the city from table B in a single query through DTS? thx for any replies.

jigen3

 

[evaleah]

You could use a LookUp for the currency value with the following query

SELECT Currency FROM B WHERE Country = ?

Then write a DTS package using an ActiveX script and use the following:
DTSDestination("Currency") = DTSLookups("Currency").Execute(DTSSource("Country"))

 

[tonedef]

You could just use the query:

[blue]SELECT[/blue]
   a.City,
   b.Currency
[blue]FROM[/blue]
   TableA as a
[blue]INNER JOIN[/blue]
   TableB as b
[blue]ON[/blue]
   a.Country = b.Country