You could keep a list of tables you want to import.

You query the metadata tables in Oracle (it should have INFORMATION_SCHEMA.COLUMNS et cetera) to find the table structures.

Create your destination tables dynamically in SQL Server and import the data using OPENROWSET commands.

Try to get some parallellism in there, since you have so much tables.