Execute SQL scripts on VM Machine using release azure devops pipeline

0
votes

I am using IIS Deployment template in Release pipeline to deploy MVC application to VM and it is working fine. But after deploying application, we want to run any ad-hoc sql changes using script files in SQL server using custom task Run SQLCMD Scripts from VSTS market place.

Relese pipeline Relese pipeline, scripts are in zip file, Can anyone suggest what we should key-in in "Path to folder containing SQLCMD script files"?

2
azure-devopsazure-pipelines
Hi @Developer , can this path meet your needs? Check this rule, if the answer could solve your question. you can consider accepting it as answer . – Kevin Lu-MSFT

2 Answers

0
votes

You can try referencing the variable $(Build.ArtifactStagingDirectory)

0
votes

In Release Pipeline, the artifacts will be downloaded to the path : $(System.ArtifactsDirectory).

According to your screenshot, I noticed that you are using the "Extract files" task. This task will find the zip files in the $(System.ArtifactsDirectory) and extract it.

The unzipped folder name is set in the "Extract files" task (Destination folder).

Extract files task

So you could try to use the following path: 

$(System.ArtifactsDirectory)/Destination folder name

You can also expand this path according to the actual location of the file.

Hope this helps.