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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-08-01 : 07:12:44
|
| 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
52326 Posts |
Posted - 2013-08-01 : 07:35:56
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-08-01 : 09:28:54
|
| 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-01 : 12:43:23
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-08-01 : 22:49:20
|
| 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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-02 : 01:38:45
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
dgh898
Starting Member
10 Posts |
Posted - 2013-08-08 : 23:08:45
|
| unspammed |
|
|
|
|
|
|
DATA LOADING FROM SAP TO ORACLE