The proxy user account needs to be associated with the group of "OLAP Administrators" on the target server. (This is less priviliged than Administrator group).
My idea is to create a simple source file with one line. This initiates the data flow. Then you add a Derived Column Transformation object, and place you variable as...