I've been tasked with migrating data from an Oracle 11g instance on one domain with partial trust(one way trust, not two way) to a SQL Server.
I can query and tnsping the source Oracle 11g instance with no problems. When I try to use the SSMS import wizard, it cannot recognize the number data type. Whomever set up the Oracle tables used this data type hundreds of times.
Is there some way I can have SSMS recognize the data type and map it to Numeric?