Post reply

(Microsoft OLE DB Provider for SQL Server (80004005): Invalid character value for cast specification.)

  • May 14, 2008 at 7:10 am

    #190513

    hI Guys ,

    I have problemwith one dts package .this problem log is

    Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump

    Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80004005): Insert error, column 15 ('date_bought', DBTYPE_DBTIMESTAMP), status 6: Data overflow.) (Microsoft OLE DB Provider for SQL Server (80004005): Invalid character value for cast specification.)

    Step Error code: 8004206A

    Step Error Help File:sqldts80.hlp

    Step Error Help Context ID :0

    Here the source and target are both on same databse SQL server .

    source datatype is varchar(200),whre as target is smalldatetime.

    This DTS package ran well till 4 days back .But now its throwing this error .Please help me how to solve it .

    Thanks in advance .

  • May 14, 2008 at 10:49 am

    #815396

    There apparently is a value in the source column that won't convert to smalldatetime. You'll have to find it and either correct it or remove it. Try designating an exception file for the task and capture source error rows.

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

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