@Robbert van Tongeren thanks for sharing your dynamic assigned CP code, 2 years later it has come in handy for us. Here is an upgraded version of the code that is compatible with at least version 2023.01 In Roberts’ words:"The goal of this procedure is that we don't have to retrieve the XML manually for all the XML variables and we have the same xml_table for each task procedure, also when we add a new parameter to the table task, this will be added automatically. This way you can use the table @xml_table in the template code for the task, instead of reading out the XML parameter every time you need some data.”All credits to @Robbert van Tongeren Code for the template:declare @xml_table table ( [comma][task_parmtr_id] [dom_id])insert into @xml_table ( [comma][task_parmtr_id])select [comma]row.value('./[task_parmtr_id][1]', '[dom_id]')from @[xml_variable].nodes('/rows/row') as c(row)Code for the control_procedure (Assignment "SQL”, code group "TASKS”):Make sure you are usin
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.