Error validating execution rights for agent Private livecam

Pipeline Description: component “Source – Sheet1$” (1) failed validation and returned error code 0x C020801C.

End Error Error: 2014-10-06 .05 Code: 0x C004700C Source: Data Flow Task 1 SSIS.

End Error DTExec: The package execution returned DTSER_FAILURE (1). Under the Execution Options tab, there is a checkbox to Use 32 bit runtime.

Checking that box and saving my job allows the import to run successfully.

Note The causes of many deployment failures can be identified by reviewing the log files created during the deployment process.

I was working through a request from a customer to import an excel spreadsheet into SQL Server on a recurring basis.

I decided to create an SSIS Package to accomplish this and then call the package from a job in SQL Server Agent.

However, when I ran the job, I received an error that the connection to my Excel file was not supported (as follows): Executed as user: CRH-W764SYSTEM.

Microsoft (R) SQL Server Execute Package Utility Version .1 for 64-bit Copyright (C) Microsoft Corporation 2010. Started: AM Error: 2014-10-06 .05 Code: 0x C00F9304 Source: test Connection manager “Source Connection Excel” Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: , as no OLE DB provider is available.

End Error Error: 2014-10-06 .05 Code: 0x C020801C Source: Data Flow Task 1 Source – Sheet1$ [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

The Acquire Connection method call to the connection manager “Source Connection Excel” failed with error code 0x C00F9304.

Tags: , ,