I want to copy data from SAP System using Theobald(Xtract IS), and run this ssis package from Azure data factory ssis activity, but it show error that invalid connection manager XTRACT
. Is there any way to run my Xtract IS (SSIS package) to copy data from SAP.
Output
{
"SsisDBOperationGuid": "186ebdff-ab1f-40ef-abe9-060d58fa9564",
"SsisDBOperationId": 2,
"OperationErrorMessages": "3/16/2020 7:34:19 AM +00:00 :
Package:Error: The connection type \"XTRACT\" specified for connection manager \"Xtract Connection\" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.\r\n\n3/16/2020 7:34:19 AM +00:00 : Data Flow Task:Error: The managed pipeline component \"XtractIS.XtractSourceTable\" could not be loaded. The exception was: Could not load type 'XtractIS.XtractSourceTable' from assembly 'Microsoft.SqlServer.PipelineHost, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..\r\n\n3/16/2020 7:34:19 AM +00:00 : Data Flow Task:Error: The \"Xtract Table\" failed to cache the component metadata object and returned error code 0x80131600.\r\n\n",
"effectiveIntegrationRuntime": "AzureSSISIR (East US)",
}
User contributions licensed under CC BY-SA 3.0