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

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SSIS Task execution fails through Job

Author  Topic 

kond.mohan
Posting Yak Master

213 Posts

Posted - 2013-04-23 : 02:22:44
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
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-04-23 : 02:28:28
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

52326 Posts

Posted - 2013-04-23 : 13:00:23
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
   

- Advertisement -