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

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.

This site uses Akismet to reduce spam. Learn how your comment data is processed.