I was working on Azure Data Factory – Automated deployments (CI/CD) using Azure DevOps and I encountered an error with the message Format of the initialization string does not conform to specification starting at index 0 while running the pipeline.
After troubleshooting, I can to know that I was referring to an incorrect Release Variable. Let me explain more about that.
My requirement was to pass Connection String of the SQL Database to Azure Data Factory Pipeline. Instead of hard coding, the connection string, I wanted to configure it in a Release variable as shown below.
As shown in the above screenshot, the variable name that holds the SQL Database connection string was DatabaseConnection. However, Instead of using the variable DatabaseConnection, I was referring to something else as shown below.
As i was referring to an incorrect variable, I was getting an error with the message Format of the initialization string does not conform to specification starting at index 0. After changing the variable to the appropriate name (SQLConnection), then I can see my pipeline got running successfully. Below is the screenshot that shows the new variables names.
Hope it helps someone who had faced similar issue.