ADO Net Source does not accept varible, So I have to use the expression in Data Flow. 1, I defind a varible User::dept_nbr, type is string, value is 5 2, open the properties of Data Flow, set "ExecValueVarible" = User::dept_nbr 3, in Expressions, set "[ADO NET Source - DS1].[SqlCommand]" = "select * form orders where dept_nbr = " + @[User::dept_nbr], the column orders.dept_nbr is integer, when I run it, the Data Flow task it self have no problem, all data is loaded, but in the control flow, the data flow is red, under is the error message: Error: The wrapper was unable to set the value of the varible specified in the Excutionvaluevarible property. Error: The type of value being assigned to varible "user::dept_nbr" differs from the current varible type. Varibles may not change type during execution. varible types are strict, except for varibles of the type object. Any one have this problem before?stong

where the User::dept_nbr variable will be loaded? maybe there is something wrong therehttp://www.rad.pasfu.com

thank you, I set the value when I defined it, then never change. that should not be the problem.stong

found the problem, I should not set "EcecValueVarible", this is for the result.stong