Difficulties in migrating BLOB fields

Prerequisites:
If the table structure changes, you can only move fields in some tables to another table (including BLOB fields ). Oracle imp/exp cannot be used, or MS sqlserver database cannot be used for import and export.

Objective 1:
Migrate all the tables in an Oracle database containing BLOB fields to Ms sqlserver.

I created a package with DTS. If all the tables are copied, an error occurs. No. In the select XXX from method, only non-BLOB fields can be migrated.

Objective 2:
Migration of Blob-type fields between two databases in MS sqlserver itself.

Because of the failure of Goal 1, I think that Goal 2 may also be difficult.

Because Oracle migration

For example, user A has a table imagesrecord.
There are fields.
Name (vchar), image (BLOB)

User B's imagesrecord shows that there is an additional year field.
Name (vchar), image (BLOB), Year (INT)

Use copy from a/A @ db01 to B/B @ DB02 append imagesrecordusing select name, image, 2004 year from imagesrecord;

Similar to the select * from database. Table migration method in MS sqlserver. I think it should be difficult. Because blob field select cannot be selected.