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
 SSIS and Import/Export (2008)
 DATA LOADING FROM SAP TO ORACLE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kond.mohan
Posting Yak Master

India
197 Posts

Posted - 08/01/2013 :  07:12:44  Show Profile  Reply with Quote
HI,
I have created ssis pkg to load the data from sap (source) to oracle destination. when I execute the pkg getting below error.
in the destionation it is showing this error.(but connecitn string is succed)

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "mis.mis" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.


mohan

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 08/01/2013 :  07:35:56  Show Profile  Reply with Quote
the error message is not informational enough. As it suggests did you check if there are any other error messages returned? The error seems to be in SAP source connection so it might be problem in setting it up inside source connection manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

kond.mohan
Posting Yak Master

India
197 Posts

Posted - 08/01/2013 :  09:28:54  Show Profile  Reply with Quote
hi visahk,
thanks for ur suggestion. when I execute the package it is getting the error from Destionationside(Oracle) but connection manager is showing succeed
[SSIS.Pipeline] Error: OLE DB Destination failed validation and returned error code 0xC020801C.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 08/01/2013 :  12:43:23  Show Profile  Reply with Quote
failed validation? is it showing any error (red baloon) when in design mode? Is the connection manager property static or based on an expression?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

kond.mohan
Posting Yak Master

India
197 Posts

Posted - 08/01/2013 :  22:49:20  Show Profile  Reply with Quote
yes. it is show the error when i executed. it seems to be sap data structure is incompatibility issue.i have converted the data using data conversation.what is structure have to create in Oracle database ?still error persists

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 08/02/2013 :  01:38:45  Show Profile  Reply with Quote
what is structure have to create in Oracle database ?
that depends on your source data. without knowing that we wont be able to answer this. can you post how the data is coming from the source?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

dgh898
Starting Member

10 Posts

Posted - 08/08/2013 :  23:08:45  Show Profile  Reply with Quote
unspammed
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.06 seconds. Powered By: Snitz Forums 2000