Description
I am using SQL database project extension in Visual Studio code, when tried to build the database project, it gave me this error
Build error SQL70001: This statement is not recognized in this context.
===================================================
Visual Studio Code Output:
[ Build ]
> "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory"
stdout: MSBuild version 17.3.4+a400405ba for .NET
stdout:
stdout: Determining projects to restore...
stdout:
stdout: All projects are up-to-date for restore.
stdout:
stdout: Creating a model to represent the project...
stdout:
stdout: Loading project references...
stdout:
stdout: Loading project files...
stdout:
stdout: Building the project model and resolving object interdependencies...
stdout:
stdout: Validating the project model...
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout:
stdout: Build FAILED.
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: 1 Warning(s)
stdout: 10 Error(s)
stdout:
stdout:
stdout: Time Elapsed 00:00:03.93
stdout:
>>> "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … exited with code: 1
>>> "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … errored out: Process exited with code 1 [ Build ]
> "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory"
stdout: MSBuild version 17.3.4+a400405ba for .NET
stdout:
stdout: Determining projects to restore...
stdout:
stdout: All projects are up-to-date for restore.
stdout:
stdout: Creating a model to represent the project...
stdout:
stdout: Loading project references...
stdout:
stdout: Loading project files...
stdout:
stdout: Building the project model and resolving object interdependencies...
stdout:
stdout: Validating the project model...
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout:
stdout:
stdout: Build FAILED.
stdout:
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj]
stdout: 1 Warning(s)
stdout: 10 Error(s)
stdout:
stdout: Time Elapsed 00:00:04.71
stdout:
>>> "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … exited with code: 1
>>> "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … errored out: Process exited with code 1