Home Forums SQL Server 2005 T-SQL (SS2K5) Problem with BULK INSERT RE: Problem with BULK INSERT
Nesuke
SSC Enthusiast
Points: 196
More actions
September 6, 2012 at 3:27 am
#1534327
Why have '^' as a delimiter for a start?
Anyway, the problem is probably the encoding of the txt file, make sure it's Unicode. Make sure your type is 'varchar' and not 'nvarchar'. Make sure the collation of the column is Latin1_General_CI_AS.