Comments (2)
Can you copy and paste the full text from your value field here in a reply? Including @joshuha ...
from adflab.
I have same issue.
Leave error message below.
{
"errorCode": "2400",
"message": "Parse error at line: 1, column: 75: Incorrect syntax near '@return_value'.",
"failureType": "UserError",
"target": "Execute SQL"
}
And full text I input to value field.
DECLARE @return_value INT, @exe_id BIGINT, @err_msg NVARCHAR(150) EXEC @return_value=[SSISDB].[catalog].[create_execution] @folder_name=N'ADFLab', @project_name=N'ADFLab', @package_name=N'Module2.dtsx', @use32bitruntime=0, @runinscaleout=1, @useanyworker=1, @execution_id=@exe_id OUTPUT EXEC [SSISDB].[catalog].[set_execution_parameter_value] @exe_id, @object_type=50, @parameter_name=N'SYNCHRONIZED', @parameter_value=1 EXEC [SSISDB].[catalog].[start_execution] @execution_id=@exe_id, @retry_count=0 IF(SELECT [status] FROM [SSISDB].[catalog].[executions] WHERE execution_id=@exe_id)<>7 BEGIN SET @err_msg=N'Your package execution did not succeed for execution ID: ' + CAST(@exe_id AS NVARCHAR(20)) RAISERROR(@err_msg,15,1) END
from adflab.
Related Issues (20)
- CreateAzureDW.sql not working HOT 1
- Module 2 doc omits VSTS git repo setup step
- Lab2 Error while deploying SSIS Package in Data Factory 2 HOT 6
- Lab 3 Issue - Cannot Find folder "adflab" or file "MASTER.txt" HOT 3
- Execute SQL - (Configure sp_executesql)
- Unclear instructions on how to configure HOT 6
- Create an example for tumbling windows trigger
- PowerShell Lab deployment HOT 10
- Problem connecting to Amazon S3 HOT 2
- LabDeploy.ps1 Fails if files not unzipped
- Lab3: Send Success Email failed
- Lab 2 Configuring Connection String
- Deployment fails: Gen1 Data Warehouse deprecated HOT 1
- @runincluster is not a parameter for procedure create_execution
- Update to DW Gen2
- Update to current Azure Screenshots
- Azure SQL Data Warehouse Gen1 has been deprecated in this region. Please use SQL Analytics in Azure Synapse.
- AirlinePerformance-ODS has no tables HOT 1
- No "AirlinePerformance-Staging" after running deployment ps1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from adflab.