I have an SSIS package with a Bulk Insert Task that was working last night. But when I tried running the same package this morning it failed.
This is the error that I get:
"[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any
information about the error.Cannot bulk load because the maximum number of errors (100) was exceeded.Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 102, column 275..."
Does anyone know why what may have caused it?
View Complete Post