Prevent Creation of Empty Files via dataflow ADF

Question

Prevent Creation of Empty Files via dataflow ADF

Balasubramani T Mohanasundaram 1

hello, how to Prevent Creation of Empty Files via dataflow to sink destination.

ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

2022-10-21T13:50:54.897+00:00

Hi @Balasubramani T Mohanasundaram ,

Just checking is below answer helps you? If yes, Please consider marking it as Accepted Answer. Accepted answers help community as well.

If below answer not helps, Please share more details on your implementation to understand what exactly dataflows is doing where its creating empty file.

1 answer

Your answer

ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

2022-10-21T13:50:54.897+00:00

Hi @Balasubramani T Mohanasundaram ,

Just checking is below answer helps you? If yes, Please consider marking it as Accepted Answer. Accepted answers help community as well.

If below answer not helps, Please share more details on your implementation to understand what exactly dataflows is doing where its creating empty file.

Answer 1

Nandan Hegde 36,716 MVP Volunteer Moderator

Hey, Can you please provide details about your source ? from which you are generating the file?

In case if it is SQL database,
You can switch to query mode in source of dataflow and check the count of query. If it is zero, throw error else provide output. As per my understanding there is no out of the box feature to validate it within copy activity.

Or you can use a look up activity or script activity prior to dataflow to do the same

Share via

Prevent Creation of Empty Files via dataflow ADF

1 answer

Your answer