Package Works In One Place And Not Another

I'm having a problem with a simple audit package.
I have a sub-select query with parameters in a SQL task. now from what I gathered we must do this as an expression so my SqlStatementSource expression is:

"UPDATE [Table1]
SET column1 = GetDate(), Success = 'Y'
WHERE
column2 = ? and column3 = ? and
Success = 'I' and column4 = (select Max(Column4) from [Table1] where column2 = ?)"

My package is saved on a network drive. When i execute this package from a RDC to another computer (the server) green lights all the way. When I execute the exact same package from my computer, RED RED RED!!!

I get the following:

Error: 0xC002F210 at [. . my query. . .] failed with the following error: "Parameter Information cannot be derived from SQL statements with sub-select queries. Set parameter information before preparing command.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


My query is already an expression so I dont know what else to do especially since it works one place and not the other. Am I missing something? (I don't want to use an SP)