How to run XTRACT IS (SSIS Package) from ADF to copy data from SAP to MS SQL

0

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)",
}
ssis
azure-data-factory
sap-basis
asked on Stack Overflow Mar 16, 2020 by Asif Khan • edited Jan 10, 2021 by Sandra Rossi

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0