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 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 

Explanation of VMware Snapshot Files Calendar Year View Web Part Code Example