This thread is for discussions of Bulk Insert from Flat File Using Transact-SQL .

Hari,

Thanx for posting this valuable code snippet.  It was really useful to me.  I learnt a new topic today.  Once again thanx.

Regards
Saravanan

Good piece of knowledge imparting code.
Got to learn something new.

I got this error . 'Cannot perform bulk insert. Invalid collation name for source column 4 in format file 'c:\bcp.fmt'.' I copied as it was on the post. Any ideas?

Hello,

I am getting the same error message:
Server: Msg 4839, Level 16, State 1, Line 1
Cannot perform bulk insert. Invalid collation name for source column 4 in format file 'c:\bcp.fmt'.

I tried to change into the bcp file the collation to be SQL_Latin1_General_CP1_CI_AS. Still doesn't work.

Someone can help me please?

 

Thanks a lot.