Home > SQL Server, SSDT, Visual Studio > Post Deployment Script, 72006: Fatal scripting error: Incorrect syntax was encountered while parsing

Post Deployment Script, 72006: Fatal scripting error: Incorrect syntax was encountered while parsing

The Problem

You create a post deployment script, with a statement like;

:r .\Static Data\Insert Seed Values.sql

The system throws an error and will not build:

72006: Fatal scripting error: Incorrect syntax was encountered while parsing ‘Data\Insert’
[/chsharp]

The solution

There are two problems:

  1. The post deployment script does not like spaces in the file paths, so quote the file path in “double quotes”.
    :r ".\Static Data\Insert Seed Values.sql"
    
  2. The post deployment script runs in SQL CMD mode, so whilst ever you have the script file open it will throw syntax errors either
    1. Close the post deployment script; or
    2. Turn on SQL CMD mode on the file, (in 2012 with latest SSDT this is the last icon in the toolbar

      SQLToolbar
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
Categories: SQL Server, SSDT, Visual Studio Tags:
  1. No comments yet.
  1. No trackbacks yet.