I want to concat some predefined values during insert from sql task.below is my script.
insert into test(id, values)
values(?,?+'mark')
i created two variables and want to insert first variable value in first column that is happening correctly and wanted to insert variable+'mark' in second but there is some error occurred.
sry for the typo, i want to insert data in name column. the problem is actually when i want to add some suffix in variable that i want to pass in execute sql task.
insert into test(id, name)
values(?,?+'mark')