SQL Server Forums
Profile | Register | 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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

210 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

2241 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  
 New 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.05 seconds. Powered By: Snitz Forums 2000