File format issue of Text file which is exported

[flora9090]

Hi,

I used TextFile (Destination) Connection to export file from the table to the text file.

For TextFile Properties, I set ‘Row delimiter’ and ‘Column delimiter’ as ‘Tab’, the file has been created successfully.

But when I create a TextFile (Source) Connection and try to open this file, by select the same option for set ‘Row delimiter’ and ‘Column delimiter’, it just prompted the error “Too many columns found in current row, non-whitepace characters were found after the last defined column’s data.”, it looks like that the row delimiter has not been applied in the text file even I set it when creating the file.

If anyone has the idea for this problem.

Very appreciate for any idea.

Flora

 

[SQLDenis]

you can not have the row and column delimiter be the same (if you want to import this file)
How would you know when the row ends?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[flora9090]

Hi,
That's good point. It is ok now by selecting different delimiter for row and column.

Thanks a lot , SQLDenis

Flora