Hi
I am trying to import a comma seperated flat file into the SQL server
table.The table has 5 field sand the first one is an auto field.
When I am importing I am getting the following error

Error Source Microsoft DataTransformationServices Flat file
Rowset Provider
Error Description Row Delimiter not found
Context Error Calling OpenRowset on the provider

Any help is appreciated
Thanks
Reddy

The error indicates that the row delimiter is not found. Do you have the row
delimiter set to CRLF, and do you try to import a file that has been
generated on a *NIX platform, where the row delimiter usually is LF only?

--
Jacco Schalkwijk
SQL Server MVP



"Prudhvi Reddy" <prudhvi_reddy (AT) telnetww (DOT) com> wrote

Thanks Jacco It worked when I changed the Row Delimiter.


Regards
Reddy



"Jacco Schalkwijk" <NOSPAMjaccos (AT) eurostop (DOT) co.uk> wrote