Omicron Llama

Coding all day, every day.

SQL Server

SSIS Error: An OLE DB error has occurred. Error code: 0x80040E09 – SELECT Permission was denied…

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 […]

Could not load package "\MSDB\MySSISPackage" because of error 0x80131500.

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 […]

Getting the current date with MDX – Another Way

I’ve been dipping my toes into the black art of MDX (or MultiDimensional Expressions) and I had a requirement whilst building a KPI that I needed to get the current date from a Dimension I had called “Date”. I had been linked to this blog: http://my.opera.com/duncans/blog/using-custom-sets-in-analysis-services-to-deliver-special-date-ranges-to-end-use but couldn’t for the life of me get his first […]