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

26 August, 2010 Roel van Lisdonk 0 Comments

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.

Tags:

Leave a Reply

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

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

Tags

Angular (16) AngularJS (28) ASP .NET (66) C# (191) Chrome (7) CSS (27) Entity Framework (17) Excel (9) HTML (8) IIS (29) Integration Services (18) Internet Explorer (11) Javascript (70) jQuery (7) Kendo (6) Kendo UI (16) LINQ (10) LLBLGen (13) MVC (7) NAnt (9) Outlook (19) Outsystems (6) PowerPivot (9) PowerShell (31) Reporting Services (21) Setup Packages (14) SharePoint (28) Silverlight (15) SQL Server (88) SSIS (17) T-SQL (44) Telerik (12) TFS (11) TypeScript (13) Unit tests (15) Visual Studio (101) Visual Studio Code (8) VMWare (10) WCF (12) WCF RIA Services (7) Windows (11) Windows 7 (34) Windows 8 (12) WPF (8) XML - XSLT - XPath (8)

Archive