2 Replies Latest reply: May 15, 2014 10:00 AM by Gareth Horton RSS

    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

        • exporting numeric field to SQL Server table
          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

          • exporting numeric field to SQL Server table
            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 /b[/quote]