Bulk Upload Error
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi Guys, Please,help with this.I am using bulk insert to upload a text file but i receive the following error message : System.Data.SqlClient.SqlException was caught Message="Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 13 (EFFECTIVE_DATE).\r\nBulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 13 (EFFECTIVE_DATE).\r\nBulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 13 (EFFECTIVE_DATE).\r\nBulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 13 (EFFECTIVE_DATE)." Thanks in Advance.