I'm trying to update an existing table in SSIS. I've been trying to use the OLE DB Command transformation with the SQL command:
UPDATE mytable
SET field1 = x
WHERE field2 = y
The problem is, I want to use values from my input columns for x and y, but it won't recognize their names. It gives the error message "invalid column name y".
What am I missing? Is there some syntax to refer to input column values? The online help is pretty unhelpful.