Forum Discussion

Thiyagarajan1980's avatar
Thiyagarajan1980
Copper Contributor
Apr 29, 2024

ADF - CDC Creates File and Folder on the same name

Hi Team,

 

My requirement is simple, if any updates/inserts/updates happened to one our Azure SQL Server database table, the CDC has to generate the .csv file for the incremental in the Azure storage.

 

It is working as expected, but the CDC creates a folder and file on the same Target Name.

 

Here is my CDC Source and Target.

 

when the Insert happened in the database, the CDC generates the incremental file, but it also generates a file outside the folder as below.

 

 

Inside the incr-mist-data/incoming/incr folder as below.

 

 

It should create the .csv file under the incr-mist-data/incoming/incr folder, but it creates a 0KB file in the folder incr-mist-data/incoming ?? Please let me know how to avoid it.

 

Thanks

Rajan

 

 

No RepliesBe the first to reply

Resources