After I narrowed down the scope, I only kept two components in the job and the error message still came up. So I think it should be the sql issue.
My revised job is as follows:
tOracleInputRow - row - tLogRow
I attached one picture for the query I used. The column name "file_name" seems in orange color. I don't know if it's a reserved words in somewhere. I guess that might be problem.
But this job works fine at my local which is window OS. It doesn't work on the server, which is linux OS. I wonder how to modify it so that it's able to work under linux system.
Thanks!!!