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 35,796 Reputation points Microsoft Employee

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.

ShaikMaheer-MSFT 35,796 Reputation points Microsoft Employee

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

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

Prevent Creation of Empty Files via dataflow ADF

1 answer

Activity