Community discussion forum

Bulk Insert from Flat File Using Transact-SQL

• • Reply

  9 years ago

  by Developer Fusion Bot

  Developer Fusion Bot

  , United Kingdom

  Joined 2 years ago

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

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  2 years ago

  by itssara

  itssara

  Chennai, India

  Joined 2 years ago

  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

  Report abuse
• • Reply

  2 years ago

  by inferano

  Paul N

  Bangalore,India, India

  Joined 3 years ago

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

  Report abuse
• • Reply

  2 years ago

  by Ayub

  Ayub Ali Ahmed

  , United Arab Emirates

  Joined 2 years ago

  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?
  
  
  
  

  Report abuse
• • Reply

  2 years ago

  by daviddesantiago

  de santiago

  , United Kingdom

  Joined 2 years ago

  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.

  Report abuse