Hi @Paul-Emmanuel BREC ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
As I understand your issue, you are trying to update data in postgreSQL using Alter Row transformation in mapping dataflow . However, it is not working as expected in your case. Please let me know if my understanding is incorrect.
I tried to replicate your scenario and was successfully able to update the table in my postgreSQL database using mapping dataflow.
Kindly make sure that columns between source and sink dataset are mapped properly in mapping tab of sink transformation. Also, use Cast transformation to make the datatype of source similar to the schema of sink table in postgre .
Here is the video you can refer to:
Hope this will help. Please let us know if any further queries.
- Please don't forget to click on or upvote button and take satisfaction survey whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators