In the Connection Manager for your SQL Server you must set RetainSameConnection=True. This is what we did in our project, but we could not get it to work for our Oracle destination tables. Worked fine for SQL Server.