• Why is the OLE DB (command or destination) turning green before the (prior step) merge has finished merging?

    Good question. I would not expect this to happen. Are you trying to process a SCD with your Description field being a historical attribute? If so, have you tried using the SCD transformation? It's pretty straight forward and it will do the exists/changed comparison for you. That or you could try the UNION ALL transformation instead of the Merge.

    John Rowan

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