'Seed Data from csv in SQL SERVER Data Tier Project

Im pretty new to SQL Server Data Tier Project. My team is using dacpac based deployment using github actions for Azure Synapse SQL Pools. I have a requirement to load data to a table from csv file located in same codebase. Need help in how this can be achieved.

I have a publish profile.xml for each environment. Also saw this

But Im not able to reproduce the solution as im getting various errors like :setvar in Post deployment script is throwing syntax error near : etc

sql-serverazure-synapsedacpacdata-tier-applications


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions