I want to export an SPSS dataset to a Teradata database. My SPSS dataset has 277 variables. I tried using the 'Export to Database' feature of SPSS with the Teradata ODBC connection, however the process fails because one or more of the variables has an incorrect data type. I've gone through each of them and checked and made sure that they are ok but it still throws out an error and does not even specify which of the variables is causing the error.
I also tried exporting the SPSS dataset to an Excel csv file, created a new table in Teradata using the Teradata Administrator and then i used the FastLoad utility in Teradata SQL Assistant to import the data, the FastLoad ran for 5 hours and failed.