I made a simple bulk task to load data from a 3-4 kb csv (.txt) file. All the data is loaded correctly and yet SSIS shows that its failed. I don't get it. Why ?
The so-called error is -
[Bulk Insert Task] Error: An error occurred with the following error message: "Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (My_ID).".
I am using SSIS 2008 and SQL server 2008 for this one.