Hi, Iam trying to set a variable in the the onerror event of the SQL query task. BUt i cant seem to get the syntax right. I have a variable cslled GetFile and I want to set it to FAIL if any error occurs. But I cant figure out how to set the varible correctly, instead I get the following error:
[8003 - sql] Invalid value 'setVariable:[GetFile]=['FAIL']' for attribute 'onError' in element 'sql'
I think I tried every possible way of formating it with no luck.