OK, I might be doing something really stupid here, but it has been driving me crazy for a few hours now.
After a whole series of steps to pull text files off an SFTP server and process their contents, the final step is to update a control table and change the "processed_flag" value from 0 to 1.
For some reason this does not work.
A Browse node shows that the correct data is available.
But the Output data node is returning this error. It looks like the required values are not being parsed into the SQL statement (...?)
Other notes...Filename is the primary key of the control table. I am using ODBC.
Any ideas on what could I be doing wrong?
Solved! Go to Solution.
Hi @Manning_Oz
How's your update query in your Output Tool?
Have you tried to run a select command with the same parameters to check it out?
Cheers,
All good, I finally figured out my mistake. There were two columns, one with the file extension included and one without, and I was making the comparison using the wrong columns.
The lesson here is that sometimes you can get too focused on the wrong thing, and forgot to cover the basics. Oh well.