Import .csv errors - 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 2000 Forums

Import/Export (DTS) and Replication (2000)

Import .csv errors

Author

Topic

devinev
Starting Member

16 Posts

Posted - 2004-10-04 : 17:15:28

I do not have a lot of experience with DTS and would appreciate some help.

I am having a problem importing a comma delimited text file into a table using DTS. The error I get is:

“The number of failing rows exceeds the maximum specified.
Transform copy “DirectCopyXForm’ conversion error: Conversion invalid for datatypes on column pair 9(source column ‘northing’(DBTYPE_STR), destination column ‘Northing’ (DBTYPE_R8)).

Source column 9 (‘Northing’) looks something like this:

3494803.7
3494803.7
3494803.7
3494803.7
3494954.56
3494954.56

Destination column ‘Northing” is designated as a float.

Can someone give a clue? Thanks

- Vee

X002548
Not Just a Number

15586 Posts

Posted - 2004-10-05 : 12:13:27

Do this...

Load everything to a table where all the columns are varchar...

Then do this

SELECT * FROM myTable WHERE IsNumeric(FloatCol) <> 1

That'll show your troubled rows.

Bottom line. You have data that does not conform to the specifications of the float datatype.

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources