The destination does not work with remote hosts in this release

Are you talking about the OLEDB destination? Only the SQL Destination has this limitation.

There is no success output on a destination to allow the return trip.

Can you explain this? Is there a reason that this work cannot be accomplished after the dataflow task with a SQL Script? Likely this will be faster and less error prone.

K