October 8, 2014 at 12:40 pm
I have a SSIS package that works when I run it manually from the MSDB folder but it will not work when I schedule it as a SQL Server Agent job.
The error I'm getting:
Code: 0xC0202009
Source: MY Connection manager "SourceConnectionOLEDB"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80004005.
An OLE DB record is available. Source: "Pervasive PSQL OLE DB Provider" Hresult: 0x80004005 Description: "-4905: The application encountered a permission error".
Code: 0xC020801C
Source: Data Flow Task 1 Source - MY TASK
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Code: 0xC0047017
Source: Data Flow Task 1 SSIS.Pipeline
Description: Source - MY TASK failed validation and returned error code 0xC020801C.
Code: 0xC004700C
Source: Data Flow Task 1 SSIS.Pipeline
Description: One or more component failed validation.
Code: 0xC0024107
Source: Data Flow Task 1
Description: There were errors during task validation.
DTExec: The package execution returned DTSER_FAILURE (1).
The user has dbo permissions on the database I'm inserting to. There are no permission settings on the Pervasive database. The step is running in 32 bit mode.
I feel like getting a baseball bat and going "Office Space" on the server.
October 9, 2014 at 2:49 pm
Is there any information that I should have supplied that I didn't? Or is my problem too niche?
I'm currently trying to understand the particulars of the connection string in the step configuration and figure out if that could be the solution.
I would love some feedback.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply