Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,716 questions
Are you using the exact same dataset for your source as you did for your previous target?
One last question on the Mapping Data Flows ......
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mike Kiser
1,536
Reputation points
Hi @MarkKromer-MSFT , @Nasreen Akter @MartinJaffer-MSFT
Ok, this one is hard to explain. My Data Flow is working great with a good output csv file. But when I try to use the output file as a source to a Copy (I have to copy it to a network drive) the preview only shows one column and I get the following error when I run the pipeline
Failure happened on 'Source' side. 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error found when processing 'Csv/Tsv Format Text' source 'OIMDataFlowOutput.csv' with row number 2: found more columns than expected column count 1.,Source=Microsoft.DataTransfer.Common,'
So the Source is also just seeing one column when there are about 10 columns.
Any ideas? This Copy is the last step in my pipeline and I thought it would be the easiest...
Thanks!
Mike Kiser
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,086 Reputation points2021-08-02T18:38:44.65+00:00 @Mike Kiser are you still facing the issue, or has it been resolved?
-
MartinJaffer-MSFT 26,086 Reputation points
2021-08-04T21:51:17.19+00:00 If you found your own solution, please share with the community.
Sign in to comment
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Ryan Abbey 1,181 Reputation points2021-07-28T22:15:08.86+00:00 -
Mike Kiser 1,536 Reputation points
2021-07-29T00:34:51.583+00:00 Hi @Ryan Abbey
Yes, that is what is puzzling! It doesn't make sense.....any ideas?
Thanks
Mike Kiser -
Ryan Abbey 1,181 Reputation points
2021-07-29T03:39:12.237+00:00 Have you looked at your CSV outside of data factory?
I note you have "Headers" as a single column within your settings, is that likely to be throwing the process off?
Sign in to comment -