如果Lookup活动在运行过程中遇到了SQL错误,可以使用以下步骤访问该错误数据:
以下是一个示例,显示如何明确访问错误数据:
错误代码:
{ "errorCode": "2200", "message": "Failure happened on 'Source' side. ErrorCode=UserErrorFailedToConnectToSqlServer,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Server ''. The provided information is not valid.,Source=,''Type=System.Data.SqlClient.SqlException,Message=Cannot connect to SQL Server ''. The provided information is not valid.,Source=.Net SqlClient Data Provider,SqlErrorNumber=87,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=87,State=0,Message=Cannot connect to SQL Server ''. The provided information is not valid.}]'", "failureType": "UserError", "target": "Copy data1" }
逐行解读错误消息:
从错误消息中获取这些信息可以帮助我们快速解决问题。