How to get a pipeline in ADF to run successfully

Question

Good morning,

I am trying to run a pipeline that copies data from a blob storage to Azure SQL database. The pipeline simply fails. Any suggestions. Your help will be greatly appreciated.

Kind Regards

Tshidiso Mazibuko.

Answer 1

Hi @Tshidiso Mazibuko ,

Thanks for using Microsoft Q&A forum and posting your query.

As Nandan Hegde, suggested sharing the complete error message would help us and the community to assist your better.

But if you are still facing the issue, I would recommend going through below troubleshooting guides and see if that helps to resolve your issue.

For Azure SQL related error: Troubleshoot the Azure Synapse Analytics, Azure SQL Database, SQL Server, Azure SQL Managed Instance, and Amazon RDS for SQL Server connectors in Azure Data Factory and Azure Synapse

For Storage related error: Troubleshoot the Azure Blob Storage connector in Azure Data Factory and Azure Synapse

Hope this info helps. But if you are still blocked and if the above troubleshooting guides didn't help, then please revert back with complete error message and we would be happy to assist you.

Thank you

---

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.