Error
2 02 2012
This is purely for my own reference, but when I upgraded 2008 R2 to SP1 it somehow corrupted my master database. As this was a dev box, I didn’t have a backup of the master database (and as I’m not a DBA, didn’t know I needed to :P), so I had to rebuild, re-add the […]
5 10 2010
Came across another common error message in SSIS, here was the output when trying to execute the package… Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 19:37:49 Error: 2010-10-05 19:37:54.67 Code: 0xC0202009 Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE […]
29 09 2010
Came across an interesting error whilst thrashing out some deployment automation scripts today. As part of the deployment it was executing a SSIS package using DTExec running on the machine local to SQL Server, thus as part of the command line it omitted the /SERVER switch, insinuating that the package I’m executing exists in the […]
15 09 2010
Recently came across an odd problem on a dev machine where any and all application pools for every website on IIS would stop as soon as any website using them was launched. I was setting up a basic WebSite in IIS7 to host a web service, and created an Application Pool for that website (using […]
30 03 2009
Finally sorted something out which had been pissing me off. This applies to ASP.NET 2.0 and SQL Server 2005. Say you have an SqlDataSource whose SELECT query calls a Stored Procedure, and when you’re at the final stages of the wizard whereby it prepares the schema, you may get an error which reads: Unable to […]