Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SSIS Task execution fails through Job
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

213 Posts

Posted - 04/23/2013 :  02:22:44  Show Profile  Reply with Quote
i created ssis(sql server2012) packge from DB2(source) TO Sql staging.(staging) for dataloading. when i executed package manully executing successfully.when executing through Sql agent i am getting below error

if any one knows explain me.

Description: ADO NET Source has failed to acquire the connection {8C743702-6F98-4CB9-961D-B05A0427B717} with the following error message: "Could not load file or assembly 'Microsoft.Adapters.SAP.SAPGInvoker.dll' or one of its dependencies. The specified module could not be found.". End Error Error: 2013-04-23 11:09:43.71 Code: 0xC0047017 Source: BSAD SSIS.Pipeline Description: ADO NET Source failed validation and returned error code 0xC0208449. End Error Error: 2013-04-23 11:09:43.71 Code: 0xC004700C Source: BSAD SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-04-23 11:09:43.71 Code: 0xC0024107 Source: BSAD Description: There were errors during task validation.

Flowing Fount of Yak Knowledge

2242 Posts

Posted - 04/23/2013 :  02:28:28  Show Profile  Reply with Quote
May be this?
Check once...

Go to Top of Page

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/23/2013 :  13:00:23  Show Profile  Reply with Quote
is the dll reference registered in the server?

SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000