I've come up with a possible work around. If you have permission to run Exe SQL Task to update the schema on the source to the dbo schema which more than likely will exist on both databases, copy the table over into the dbo schema in the destination, Update the src tables back to original schema, then update the destination to the desired schema in anothe exe sql task.