Omicron Llama

Coding all day, every day.

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 DB error has occurred. Error code: 0x80040E09. 
An OLE DB record is available.  Source: “Microsoft SQL Server Native Client 10.0”  Hresult: 0x80040E09  Description: “The SELECT permission was denied on the object ‘dimMyDimension’, database ‘MyDataWareHouse’, schema ‘dbo’.”. 
End Error 
Error: 2010-10-05 19:37:54.67 
   Code: 0xC004706B 
   Source: Data Flow Task SSIS.Pipeline 
   Description: “component “OLE DB Source” (1)” failed validation and returned validation status “VS_ISBROKEN”. 
End Error 
Error: 2010-10-05 19:37:54.68 
   Code: 0xC004700C 
   Source: Data Flow Task SSIS.Pipeline 
   Description: One or more component failed validation. 
End Error 
Error: 2010-10-05 19:37:54.68 
   Code: 0xC0024107 
   Source: Data Flow Task 
   Description: There were errors during task validation. 
End Error 
DTExec: The package execution returned DTSER_FAILURE (1). 
Started:  19:37:49 
Finished: 19:37:54 
Elapsed:  5.172 seconds 

The simple answer to this is to go into SQL Server Management Studio, open up the Database, go into Security, then Users, and add in the user under which your SSIS Package is trying to run (If the user can’t be found in the database engine then it needs to be added as a Login), and ensure it owns and has membership in the db_datareader and db_datawriter roles.

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

Leave a Reply to Neil Pullinger Cancel reply

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