Comments (4)
It is better to use Stored Procedure for Upsert (Update and Insert) activities.
from azure-datafactory.
you can also use lookup activity for this. you just write sequence of queries in it. But in the last statement you can keep select 1 as x;
from azure-datafactory.
Am using Copy Activity where I want to update a value after the complete process gets over. So, in order to update a value, am using an UPDATE query. Actually it updates the value in a table but it fails the activity with the following ERROR :
"errorCode": "2200",
"message": "Failure happened on 'Source' side. ErrorCode=UserErrorInvalidDbQueryString,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException, Message=The specified SQL Query is not valid. It could be caused by that the query doesn't return any data. Invalid query: 'UPDATE tablename SET column1 = getdate() WHERE column2 = ' ' and column3= ' '.Source=Microsoft.DataTransfer.ClientLibrary,'",
"failureType": "UserError",
"target": "Copy Data 1"
Is it possible to update a query with a success status in COPY ACTIVITY ??
Are you using the SQL POOL DATABASE.
from azure-datafactory.
Chain a stored procedure activity after copy activity to update value should be the recommended way.
from azure-datafactory.
Related Issues (20)
- Pass Authorization header to Odata connector in Pipeline
- ADF Datasets - HTTP Datastore is missing HOT 1
- Issues with special character 🤯🤯
- Copy activity mappings not displayed in Dark theme HOT 2
- Error updating SQL Sink with '""' in string column(s)
- Source/Sink behaving differently when using parameterized Datasets
- Exclude Managed Private Endpoints from ARM Template Export
- Update @microsoft/azure-data-factory-utilities to work with newer Node.js versions than 18.x
- @microsoft/azure-data-factory-utilities - validation error: Pipeline has more than the max number of 40 activities allowed per pipeline. HOT 2
- Filepath option wrong delete all adf resources
- Data flow: toBase64 adds break lines after 76th character in specific ADF location HOT 1
- Azure Function call validation problem with empty JSON
- [Critical] SAP BW via MDX connector -- missing Load balancing option
- Copy activity unzipping nested zip files along with root zip file.
- Web activities fail occasionally with MissingMethodException HOT 2
- PrePostDeployentv2 Script Error HOT 4
- PrePostDeploymentScript.Ver2.ps1 stopping all the triggers
- Fix a typo in Install-Gateway() function HOT 1
- Get-SortedPipelines HOT 2
- PrePostDeploymentScript.Ver2 Fails on Start Triggers - "Getting pipelines" HOT 3
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 azure-datafactory.