• Can you not use a lookup transformation instead of Merge? It's always good over Merge with the type of activity you are doing.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.