August 26, 2010 – Knowledgebase

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

26 August, 2010 Roel van Lisdonk 0 Comments Uncategorized 15:46

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…

Change recovery model for all SQL server database to Simple, truncate and shrink log files with T-SQL

26 August, 2010 Roel van Lisdonk 5 Comments Uncategorized 08:56

When you have many databases on a database development SQL server and these databases are re-creatable, you can save space by setting the recovery model for all databases to Simple, truncate and shrink the log…

Day: August 26, 2010

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

Change recovery model for all SQL server database to Simple, truncate and shrink log files with T-SQL