October 7, 2009 at 4:53 am
Hi All
I get the following error when running SSIS package via SQL Agent job:
Started: 9:39:55 AM Error: 2009-10-07 09:39:57.57 Code: 0xC0202009 Source: p_INPUT Connection manager "package" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007007E. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x8007007E Description: "The specified module could not be found.". End Error Error: 2009-10-07 09:39:57.58 Code: 0xC020801C Source: LOAD SOURCE FILE Datavoir [5044] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Datavoir" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2009-10-... The package execution fa... The step failed.
The package executes successfully via Explorer, but fails through the SQL Agent job
1. Developer designed package
2. I loaded the package via SSIS on Integration Services via SSMS
3. Loaded the SSIS package in SQL job
4. Job fails when I execute it; with above error
Could this perhaps be a security issue within SQL Server Agent? Or must something be changed via SQL Agent properties?
Regards
Anchelin
October 7, 2009 at 4:59 am
Sounds like their is an issue regarding that connection, what is the type of connection, and does that destination exist and what permissions are needed to access that connection.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 7, 2009 at 5:03 am
Hi there
Will you be able to guide me in the right direction, where I'll be able to find this information?
Or should I ask the person that developed the SSIS package?
Thanks
A
October 7, 2009 at 5:21 am
Anchelin (10/7/2009)
Hi thereWill you be able to guide me in the right direction, where I'll be able to find this information?
Or should I ask the person that developed the SSIS package?
Thanks
A
It might be easier to go to the developer, otherwise you would have to look at the SSIS package using BIDS. all you need to know is what that connection is used for. and then you can take it from there.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply