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