dts to import csv files error - 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

General SQL Server Forums

New to SQL Server Programming

dts to import csv files error

Author

Topic

smorty44
Yak Posting Veteran

93 Posts

Posted - 2008-01-31 : 12:47:11

I'd like to set up a dts package to import .csv files and on testing one .csv with only one row I am getting this error:

Error Source: Microsoft Data Transformation Services Flat File Rowset Provider

Error Description: Too many columns found in the current row; non-whitespace characters were found after the last defined column's data.

data set from .csv:
-31,0,"CENTER","","","64 ROCK DR. #4100","BETH","MD.","20417","0470-5",30109,10598,"52492000 083","1018","406800","6896CE","7007","G00887",1,13983.24,2139.66,42741.9,150101.36,830317.41,1562843.99,30128.45,2,506,0,0,0,0,0,0,37.87,1,0,0,476.39,472.15,0,1191.12,0,90073.46,43038.97,0,309926.59,-14880.49,20060102,20090101,"A","","",""," ","C62454",0,0,0,0,0,0,0,0,8.39,0,0,0,0,"",0,"00000000",""

pravin14u
Posting Yak Master

246 Posts

Posted - 2008-02-01 : 00:01:27

The issue should be issue the values in each of the rows of your text file. I could not say anything with your sample data. Have you given the 1st 3 rows of your text file?

Just see the preview of your source and see if you can figure any issues.

pravin14u
Posting Yak Master

246 Posts

Posted - 2008-02-01 : 00:09:40

Also can you please give the row and column delimeter that you are using?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources