SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

kond.mohan
Posting Yak Master

India
197 Posts

Posted - 04/23/2013 :  02:22:44  Show Profile  Reply with Quote
hi,
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.

bandi
Flowing Fount of Yak Knowledge

India
2223 Posts

Posted - 04/23/2013 :  02:28:28  Show Profile  Reply with Quote
May be this?
Check once...
http://imgalib.wordpress.com/2013/01/24/how-to-solve-ssis-error-code-0xc020801c0xc004700c0xc0047017/

--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

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

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
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.09 seconds. Powered By: Snitz Forums 2000