Hi all,

I have found that it is not possible to avoid the generation of dynamic SQL code if you want to parameterized a SQL Server object name (sysname). However, I found this great article: Using the MERGE Statement in SSIS Via a Stored Procedure[/url] and as far as I'm concerned this thread is closed.

Kind Regards,