Azure DevOps: sourcetype is automatically converted from ExcelSource to CopySource after deployment

Question

Hi Team,

We are using Azure DevOps for Datafactory deployments. In our process we are using copy activity with source type as CSV format of files and able to deploy all these pipelines and their related datasets successfully.

But right now our source file type is in form of Excel sheet and this is where we are getting an issue with the deployment. I have attached screenshots of the files that have check-in in our repository and after deploying the sourcetype is automatically converted from Excel to dataset(In dataset json file) and ExcelSource to CopySource(In pipeline json file).

Could someone suggest where we have done mistake or how it can be resolved.

Apologies if any mistakes in the question.

Answer 1

Hi @Pujari, Lavanya (External) ,

Please note that Azure DevOps is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Azure DevOps forum over here:
https://developercommunity.visualstudio.com/report?space=21&entry=problem

If your question is more related to Azure Data Factory, then you have posted in the right forum :)

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Best regards,
Leon