Bulk insert sql 2000 and 2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Bulk insert sql 2000 and 2005

Author

Topic

Weicheng
Starting Member

5 Posts

Posted - 2009-07-23 : 12:15:24

Hi all,

I am wondering if there is any difference between bulk insert in sql server 2000 and 2005.

I have a bulk insert in sql server 2000 that works, but the same statement doesn't work on sql server 2005.

And the data feed is the same.

This is the error I got in sql server 2005.

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 250, column 44 (delta_10bp_5Y).

Msg 4864, Level 16, State 1, Line 1

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 253, column 44 (delta_10bp_5Y).

Msg 4865, Level 16, State 1, Line 1

Cannot bulk load because the maximum number of errors (10) was exceeded.

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

Any difference in sql 2005 treating data feed from sql 2000?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-23 : 12:27:13

Seems you have some bad data in the source

From BOL:

"In SQL Server 2005, BULK INSERT enforces new, stricter data validation and data checks of data read from a file that could cause existing scripts to fail when they are executed on invalid data. For example, BULK INSERT now verifies that:

The native representations of float or real data types are valid.

Unicode data has an even-byte length."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources