question

arkiboys avatar image
0 Votes"
arkiboys asked SathyamoorthyVijayakumar-MSFT edited

data flow error

Any thoughts on why I am getting this error?
Thank you

137969-image.png


azure-data-factory
image.png (58.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SathyamoorthyVijayakumar-MSFT avatar image
0 Votes"
SathyamoorthyVijayakumar-MSFT answered SathyamoorthyVijayakumar-MSFT edited

Hello @arkiboys

Thanks for the question and using Microsoft Q&A.

From the error - I see that you are making use of the Delta Format.

Looking closely at the error.

There is a column in the source side that is being referenced : vw_Department

It is erroring out because the column is not available - when the ADF is running.

From the error I see only the below columns to be present

Destination side: DepartmentID,Name,GroupName,ModifiedDatate,CurrentDae,LoadDate
Source side : DepartmentID,Name,GroupName,ModifiedDate,CurrentDate,LoadDate, r8d4e......35f39(GuidColum)

Can you pls check whether there is any reference to vw_department at the sink transformation ?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

solved. thank you
How do I set this post to answered?

0 Votes 0 ·

Thanks for the update @arkiboys . I have converted the post to an answer. You should now be able to accept the answer by clicking 130616-image.png button.

0 Votes 0 ·