{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/f925b7cb9f7e4f12ad81200f2ad0836a\" frameborder=\"0\" width=\"3840\" height=\"2880\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":2880,"width":3840,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":2880,"thumbnail_width":3840,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/f925b7cb9f7e4f12ad81200f2ad0836a-0b68a06032e934d6.gif","duration":253.5375,"title":"AETL - Update values in SQL tables using SQL Script in Packages","description":"In this video, I walk you through the process of updating a SQL table, specifically how to change a task ID in our base-camp checklist. We start by creating a SQL script that sets the task ID to a new value, which I've set to 9.99 for this example. I demonstrate how to ensure the script runs correctly by replacing variables and connecting to the right SQL script. It's important to remember to set the replacement variable to true to avoid errors. Please follow along and implement these steps in your own environment."}