I recently installed SQL Server Management Studio 2012. When using the import wizard I get data type errors when I allow the wizard to suggest types. It suggests something of the form "DOUBLE PRECSION" where the SQL Server only knows "float".
I am using SQL Server Version 9.00.4035.00. Thanks for your help.