exporting numeric field to SQL Server table

[skiz]

Hi,

I am trying to export a numeric field (length of 2) into a sql server 'int' column. The error I get is 'fields in table do not match fields in export data set'.
I tried exporting it as a 'char' field into a the sql server ''int' field, it didn't like that either.
any help would be much appreciated!

skiz

[skiz]

Hi again,

I also have another field that is a 'date/time' field and it's going to a sql server 'date/time' field, however it's only importing the date, NOT the time into sql server.

Thank you,

Skiz

[Gareth Horton]

Hi,

Let us know what version of Data Pump you are using.

Originally posted by skiz:
Hi,

I am trying to export a numeric field (length of 2) into a sql server 'int' column. The error I get is 'fields in table do not match fields in export data set'.
I tried exporting it as a 'char' field into a the sql server ''int' field, it didn't like that either.
any help would be much appreciated!

skiz