| Bertan ARI [MSFT] 2005-05-12, 8:24 pm |
| Unfortunately, Bulkload can not report which row\element is causing the
error.
You may try to find the erroneous node by minimizing the input data. This is
the best approach I know.
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
" MSSQLServerDeveloper
" < MSSQLServerDeveloper
@discussions.microsoft.com>
wrote in message news:F0B2EB06-3070-4001-B18A- 14BD3414066A@microso
ft.com...
> I am trying to run a bulk load and it fails with an error of "Invalid cast
> specification".
> In reviewing the error log, I get the following -
>
> How do I know what ROW and COLUMN is causing the error??
>
> <?xml version="1.0"?><Error><Record><HResult>0x80004005</HResult>
> <SQLState>22018</SQLState><NativeError></NativeError>
> <Source>Microsoft OLE DB Provider for SQL Server</Source>
> <Description><![CDATA[Invalid character value for cast
> specification.]]></Description>
>
</Record><Record><HResult>0x80004005</HResult><SQLState>22018</SQLState><Nat
iveError>
> </NativeError><Source>Microsoft OLE DB Provider for SQL
> Server</Source><Description>
> <![CDATA[Invalid character value for cast
> specification.]]></Description></Record></Error>
>
|