I was facing the similar issue. In my case, I was creating the SQL query on run time using script task, storing it in a variable. The default value that I had provided to my variable , one of the column names had the first character in Upper case. But in the script task, while designing the query, the same column had the first character in Lower case. On changing the latter to Upper case solved my problem. Quite strange, but it worked for me.