Post reply

Error Message from SQL when using DTS to import

  • July 1, 2008 at 5:07 am

    #193397

    Hi,

    I'm trying to import data from an Informix database to Sql Server 2000, using DTS packages.

    Some of the tables import fine, with no problems, but others are producing error messages like follows:

    'The number of failing rows exceeds the maximum specified.

    Insert error, column 7 ('ret_date', DBTYPE, DBTIMESTAMP), Status 6: Data Overflow

    Invalid character value for cast specification.'

    What does this mean? Is there a fault on the table I'm importing?

    Thanks,

    Stuart.

  • July 1, 2008 at 9:31 am

    #836780

    It looks like DTS was unable to convert the data in the column ret_date to a SQL Server datetime data type. You could try using a query in the Data Transformation task to select the input data and explicitly convert it.

    Greg

  • July 2, 2008 at 2:18 am

    #837042

    Thanks Greg. I'm quite new to all this - how do I explicitly convert it in a query?

    Thanks,

    Stuart.

  • July 2, 2008 at 3:23 am

    #837064

    Have managed to get it working, thanks anyway.

    Stuart

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy