You can change data access mode for the oleDB destination object to "table name or view name variable" then assign a value to the variable via an expression or other ssis task