Empty File is getting created in ADF

%3CLINGO-SUB%20id%3D%22lingo-sub-2625037%22%20slang%3D%22en-US%22%3EEmpty%20File%20is%20getting%20created%20in%20ADF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625037%22%20slang%3D%22en-US%22%3EI%20have%20a%20ADF%20pipeline%2C%20which%20has%20data%20flows.%20The%20data%20flows%20reads%20excel%20file%20and%20puts%20the%20records%20to%20a%20SQL%20DB.%20The%20incorrect%20records%20are%20pushed%20to%20a%20Sink%20of%20Blob%20Storage%20as%20CSV%20File.%20When%20all%20the%20records%20are%20correct%20and%20empty.%20csv%20file%20is%20getting%20created%20and%20pushed%20to%20Blob.%20How%20can%20I%20avoid%20creation%20of%20this%20empty%20file.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2625037%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EADF%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633964%22%20slang%3D%22en-US%22%3ERe%3A%20Empty%20File%20is%20getting%20created%20in%20ADF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633964%22%20slang%3D%22en-US%22%3EThis%20forum%20is%20for%20support%20for%20Microsoft%20Learn%20and%20Microsoft%20training.%20%3CBR%20%2F%3ETry%20another%20community%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunities%2Fct-p%2Fcommunities%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunities%2Fct-p%2Fcommunities%3C%2FA%3E%3C%2FLINGO-BODY%3E
Frequent Visitor
I have a ADF pipeline, which has data flows. The data flows reads excel file and puts the records to a SQL DB. The incorrect records are pushed to a Sink of Blob Storage as CSV File. When all the records are correct and empty. csv file is getting created and pushed to Blob. How can I avoid creation of this empty file.
0 Replies