Teradata Import from SPSS

Database

Teradata Import from SPSS

Hi there,

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.

Below is the data structure as in SPSS:
Type Size Decimal
R 1 Numeric 8 2
INTNUMX String 4 0
INTNUM Numeric 11 0
ADR_ID Numeric 11 0
KEYQUEST String 10 0
INTCODE String 8 0
INTNAME String 26 0
IDAY Numeric 11 0
IMONTH Numeric 11 0
IYEAR Numeric 11 0
SHOUR Numeric 11 0
SMIN Numeric 11 0
SSEC Numeric 11 0
EHOUR Numeric 11 0
EMIN Numeric 11 0
ESEC Numeric 11 0
CONTACT Numeric 11 0
KQUEST Numeric 11 0
PROREG Numeric 11 0
PROACTIVEID Numeric 11 0
PACKTYPE Numeric 8 2
SERVPROVIDER Numeric 8 2
NETWORK Numeric 11 0
DLANG Numeric 11 0
AVGSPECON Numeric 8 2
AVGSPEPRE Numeric 11 0
MODANSWER Numeric 11 0
COUNTRY Numeric 11 0
INTTYPE Numeric 11 0
A1QUOTA Numeric 11 0
A15QUOTA Numeric 11 0
D5 Numeric 11 0
Q_REGION Numeric 11 0
RACE Numeric 11 0
CONAGAIN Numeric 8 2
MONTH String 3 0
P1 Numeric 11 0
P2 Numeric 11 0
P2A Numeric 8 2
P3 Numeric 11 0
GOODDAY Numeric 11 0
CALLBACK Numeric 11 0
LANG Numeric 11 0
A1 Numeric 11 0
A5 Numeric 11 0
A5B Numeric 11 0
D1 Numeric 11 0
A9 Numeric 11 0
A14 Numeric 11 0
A15 Numeric 11 0
A15B Numeric 8 2
A16 Numeric 11 0
A16B Numeric 11 0
A17 Numeric 11 0
A18 Numeric 11 0
A10 String 250 0
A11 String 250 0
A12 Numeric 8 2
LANGOTH Numeric 8 2
A1OTH Numeric 8 2
A10_1 String 253 0
A10_2 String 169 0
A10_3 String 76 0
A11_1 String 255 0
A11_2 String 112 0
A11_3 Numeric 8 2
A12_1 String 255 0
A12_2 String 120 0
A12_3 Numeric 8 2
B24other String 26 0
B99other String 7 0
B101other String 29 0
B102other String 12 0
B104other String 7 0
B1 Numeric 11 0
B1B Numeric 11 0
B1C Numeric 11 0
B2 Numeric 11 0
B6 Numeric 11 0
B7 Numeric 8 2
B9 Numeric 11 0
B10 Numeric 11 0
B138 Numeric 11 0
B12 Numeric 11 0
B13 Numeric 11 0
B14 Numeric 11 0
B15 Numeric 11 0
B16 Numeric 11 0
B17 Numeric 11 0
B18 Numeric 11 0
B23 Numeric 11 0
B25 Numeric 8 2
B30 Numeric 11 0
B31 Numeric 11 0
B34 Numeric 8 2
B36 Numeric 8 2
B37 Numeric 8 2
B38 Numeric 8 2
B39 Numeric 8 2
B40 Numeric 8 2
B41 Numeric 8 2
B42 Numeric 8 2
B43 Numeric 8 2
B44 Numeric 8 2
B46 Numeric 11 0
B48 Numeric 8 2
B49 Numeric 8 2
B50 Numeric 8 2
B51 Numeric 8 2
B52 Numeric 8 2
B53 Numeric 8 2
B54 Numeric 8 2
B55 Numeric 8 2
B56 Numeric 8 2
B57 Numeric 11 0
B59 Numeric 8 2
B60 Numeric 8 2
B61 Numeric 8 2
B151 Numeric 8 2
B62 Numeric 8 2
B63 Numeric 8 2
B64 Numeric 8 2
B67 Numeric 11 0
B68 Numeric 11 0
B69 Numeric 11 0
B70 Numeric 11 0
B154 Numeric 11 0
B71 Numeric 11 0
B72 Numeric 11 0
B74 Numeric 11 0
B80 Numeric 11 0
B81 Numeric 11 0
MAKECDX Numeric 11 0
MODELCDX Numeric 11 0
B84 Numeric 11 0
B85 Numeric 11 0
B86 Numeric 11 0
B155 Numeric 11 0
B87 Numeric 11 0
B88 Numeric 11 0
B91 Numeric 11 0
B96 Numeric 11 0
B97 Numeric 11 0
B99 Numeric 8 2
B100 Numeric 8 2
B102 Numeric 8 2
B103 Numeric 8 2
B104 Numeric 8 2
B105 Numeric 8 2
B24_1 Numeric 11 0
B24_2 Numeric 11 0
B24_3 Numeric 11 0
B24_4 Numeric 11 0
B24_5 Numeric 11 0
B24_6 Numeric 11 0
B24_7 Numeric 11 0
B24_8 Numeric 11 0
B24_9 Numeric 11 0
B24_10 Numeric 11 0
B24_11 Numeric 11 0
B24_24 Numeric 11 0
B24_25 Numeric 11 0
B24_27 Numeric 11 0
B24_98 Numeric 11 0
B24_99 Numeric 11 0
B33_1 Numeric 11 0
B33_2 Numeric 11 0
B33_3 Numeric 11 0
B33_4 Numeric 11 0
B33_5 Numeric 11 0
B33_6 Numeric 11 0
B33_97 Numeric 11 0
B33_99 Numeric 11 0
B35_1 Numeric 11 0
B35_2 Numeric 11 0
B35_3 Numeric 11 0
B35_4 Numeric 11 0
B35_5 Numeric 11 0
B35_6 Numeric 11 0
B35_7 Numeric 11 0
B35_8 Numeric 11 0
B35_9 Numeric 11 0
B35_10 Numeric 11 0
B35_11 Numeric 11 0
B35_12 Numeric 11 0
B35_98 Numeric 11 0
B35_99 Numeric 11 0
B45_1 Numeric 11 0
B45_2 Numeric 11 0
B45_3 Numeric 11 0
B45_4 Numeric 11 0
B45_6 Numeric 11 0
B45_97 Numeric 11 0
B45_98 Numeric 11 0
B45_99 Numeric 11 0
B47_1 Numeric 11 0
B47_2 Numeric 11 0
B47_3 Numeric 11 0
B47_4 Numeric 11 0
B47_5 Numeric 11 0
B47_6 Numeric 11 0
B47_97 Numeric 11 0
B47_99 Numeric 11 0
B58_1 Numeric 11 0
B58_2 Numeric 11 0
B58_3 Numeric 11 0
B58_4 Numeric 11 0
B58_5 Numeric 11 0
B58_6 Numeric 11 0
B58_97 Numeric 11 0
B98_1 Numeric 11 0
B98_2 Numeric 11 0
B98_3 Numeric 11 0
B98_99 Numeric 11 0
B101_1 Numeric 11 0
B101_2 Numeric 11 0
B101_3 Numeric 11 0
B101_7 Numeric 11 0
B101_97 Numeric 11 0
B101_98 Numeric 11 0
B101_99 Numeric 11 0
TIME Date 11 2
TIME_MIN Numeric 11 0
D4 Numeric 11 0
D6 String 22 0
CITYTOWN Numeric 11 0
RELEASE Numeric 11 0
QUOTA Numeric 8 2
Verbatim String 423 0
A13a01 String 28 0
A13a02 String 28 0
A13a03 String 28 0
A13a04 String 28 0
A13a05 String 28 0
A13a06 String 8 0
A13a07 String 8 0
A13a08 String 8 0
A13a09 String 8 0
A13a10 String 8 0
A13a_globalsupercode01 Numeric 8 2
A13a_globalsupercode02 Numeric 8 2
A13a_globalsupercode03 Numeric 8 2
A13a_globalsupercode04 Numeric 8 2
A13a_globalsupercode05 Numeric 8 2
A13a_globalsupercode06 Numeric 8 2
A13a_globalsupercode07 Numeric 8 2
A13a_globalsupercode08 Numeric 8 2
A13a_globalsupercode09 Numeric 8 2
A13a_globalsupercode10 Numeric 8 2
A13a_globalsupercode11 Numeric 8 2
A13b01 String 26 0
A13b02 String 26 0
A13b03 String 26 0
A13b04 String 8 0
A13b05 String 8 0
A13b06 String 8 0
A13b07 String 8 0
A13b08 String 8 0
A13b09 String 8 0
A13b10 String 8 0
A13b_globalsupercode01 Numeric 8 2
A13b_globalsupercode02 Numeric 8 2
A13b_globalsupercode03 Numeric 8 2
A13b_globalsupercode04 Numeric 8 2
A13b_globalsupercode05 Numeric 8 2
A13b_globalsupercode06 Numeric 8 2
A13b_globalsupercode07 Numeric 8 2
A13b_globalsupercode08 Numeric 8 2
A13b_globalsupercode09 Numeric 8 2
A13b_globalsupercode10 Numeric 8 2
A13b_globalsupercode11 Numeric 8 2
A13b_globalsupercode12 Numeric 8 2
Analysis_Month String 20 0
weight Numeric 8 6
A15_PaymentMethodGrouped String 8 0
NPS_Profile Numeric 8 2
Overall_recommendation_REC String 10 0

Can anyone assist me in mapping these datatypes to a Teradata Table? With the correct data types?

Thanks,
Nabeel