ADF V2简单复制数据管道失败... [英] ADF V2 simple copy data pipeline failing...

问题描述

我正在尝试创建简单的管道，将csv文件从azure blob复制到azure sql数据仓库。虽然验证成功，但在错误显示时触发

I am trying to create simple pipeline that copies csv file from azure blob to azure sql data warehouse. though validation was successful, when triggered below error displaying

活动复制Data1失败：ErrorCode = FailedDbOperation，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message =在将数据加载到SQL数据仓库时发生错误。，Source = Microsoft.DataTransfer.ClientLibrary，''Type = System.Data .SqlClient.SqlException，Message =不正确
语法附近&'HADOOP&'，Source = .Net SqlClient数据提供者，SqlErrorNumber = 102，Class = 15，ErrorCode = -2146232060，State = 1，错误= [{Class = 15，Number = 102，State = 1，Message =语法附近& HADOOP&。，}，]，'

有人可以帮我解决这个问题吗？

can someone help me to fix this?

推荐答案

你好，因为你提到管道通过验证了，所以
，t你发布的错误是在运行时抛出的， 我认为你应该看一下管道的映射部分，看看映射是否正确。我们还可以关注关键字Hadoop  ，
你有csv文件中记录"Hadoop"的任何数据行吗？如果是，我将尝试找出该记录与其他记录的不同之处。

Hi there,

Since you mentioned that the pipeline passed validation, the error which you posted is thrown at runtime,  I think you should look at the mapping section of the pipeline and see the mapping is correct . we could also focus on the keyword Hadoop  , do you have any data row with the record "Hadoop" in the csv file ? if yes , I will try to find out how that record is different then others .

这篇关于ADF V2简单复制数据管道失败...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！