If you wish a question to be focused on Integration Services, please post your question within the Integration Services forum (http://www.sqlservercentral.com/Forums/Forum364-1.aspx).

However, a quick search led me to http://blogs.msdn.com/b/jorgepc/archive/2010/12/09/synchronize-two-tables-using-sql-server-integration-services-ssis-part-ii-of-ii.aspx and http://blogs.msdn.com/b/jorgepc/archive/2010/12/07/synchronize-two-tables-using-sql-server-integration-services-ssis-part-i-of-ii.aspx, which appear to broach the same methods we had offered, adds to them, and appears to answer most of your remaining questions.

As far as whether harnessing an OLE DB or an ODBC connection poses a problem (I don't think it does), I believe members of above forum would be able to offer you some further SSIS-specific guidance. As far as a single step is concerned, you may wish to post in above forum why it is imperative to accomplish what you desire within one step.