SSIS error: Column "…" cannot be found or is not specified for query (13865)

When I refreshed a SSIS package OLE DB Source, I got the error: column "test" cannot be found or is not specified for query (13865).

This was caused by the fact, that the query contained a column that did not exist anymore in de database.

Removing the column name in the SqlCommand resolved this error.

Leave a Reply

Your email address will not be published. Required fields are marked *