OK, what i did in the end:
I grabbed my Clients table and added a column for APName. If i added without OID it broke the table, returned no rows. So I had to include a valid OID as dummy.
In the transformation script i looked up my AP table for the names and replaced the values in this newly created column.
Works ok, though have the feeling there is a better way.