Hello, 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? ThanksKajo

Go to row 102 column 275, you will find a suspicious character. It does not belong to the codepage you use. It is a data input issue. I suggest you implement error redirect to trap those issues without failing the package.Arthur My Blog

Your hint to column 275 helped. I removed column 275 from the table and it worked....thanks!Kajo