Ya putaus' sdelat DDQ ispolsyya lookups query.
Eto moi code v ActiveX script(transformation):
DTSLookups("FindPK").Execute(DTSSource("pvuser").value)
kak videte y menya odin field peredaetcya v lookup query. Kak mne peredat neskolko fieldov dlya lookups query.

Mne nyshno sdelat transfer meshdy SQL i AS400. Y menya est' primary key(4 fielda) na AS400. Esli eti primary key est update table v As400, esli net to insert.
Ya yshe napoloviny sdelala etot project. Problema v tom cho ya ne snau kak peredat 4 fields v Lookups query in DDQ. Odin fields y menya idet bez problem, a vot 4 ??? Eto moi code v ActiveX script(transformation), no on ne rabotaet
DTSLookups("FindPK").Execute((DTSSource("pvuser").value) and (DTSSource("pvpajy").value) _
and (DTSSource("pvpajd").value) and (DTSSource("pvpadn").value))