question

ewinkiser avatar image
0 Votes"
ewinkiser asked MartinJaffer-MSFT commented

One last question on the Mapping Data Flows ......

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




118629-screenshot-2021-07-28-140553.jpg118774-screenshot-2021-07-28-140630.jpg118740-screenshot-2021-07-28-140710.jpg


azure-data-factory
· 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.

@ewinkiser are you still facing the issue, or has it been resolved?

0 Votes 0 ·

If you found your own solution, please share with the community.

0 Votes 0 ·

1 Answer

RyanAbbey-0701 avatar image
0 Votes"
RyanAbbey-0701 answered RyanAbbey-0701 commented

Are you using the exact same dataset for your source as you did for your previous target?

· 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.

Hi @RyanAbbey-0701

Yes, that is what is puzzling! It doesn't make sense.....any ideas?

Thanks
Mike Kiser

0 Votes 0 ·

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?

1 Vote 1 ·