There is no need to use an activex task unless you want to enrich or change the data you are copying in.

Just write your query inside a Transform Data Task between the 2 connections.

Example, 'Select columns... from DTS_companies where not exists (select * from

MAXSYR_COMPANIES)'

Then you can match the columns up on the transform tab.