• If you are just trying to insert a row if it does not exist, why not use a lookup transformation? If your row has a unique key available, this should be a simple, easy way to do this. Set the error output for the lookup transformation to route failed lookups to an OLE DB Destination component (which would be better than OLE DB Command because OLE DB Command processes each row in the pipeline one-at-a-time).

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden