Copy Data in Fabric

[tan_thiamhuat]

I tested with it, whether there is data from the Source or not, it still goes to "On Success".

What I need is when there is no data from the Source, it should go to "On fail".

Can anyone quickly confirm this?

Thanks.

[v-prasare]

Hi @tan_thiamhuat,

No, Copy Activity does not fail by default on no data. This is by design Copy Activity does not fail when it copies zero rows. to make it as you intended, you use a pre-check with a Lookup activity to detect empty source and an If Condition to either proceed or fail. This ensures the Copy Activity only runs when there is data, and you explicitly route the pipeline to fail when the source is empty.

Thanks,

Prashanth Are

MS Fabric community support

If this my response resolves your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

[tan_thiamhuat]

are you able to do some printscreen to illustrate? How do we detect if there is a file in the SFTP Server?