I am using the SSIS data source reader to connect to a MySQL database. Am I able to use expressions with this Data Flow Source. I need to pass a variable to the SQL code? I am using SQL 2005. Mr Shaw

See this MSDN post http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/6c786cf7-fbb9-4580-a323-3c6c0ef2524e/ must be the answer to your inquiry.Arthur My Blog

See this MSDN post http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/6c786cf7-fbb9-4580-a323-3c6c0ef2524e/ must be the answer to your inquiry. Arthur My Blog I can not see the expression property in the datasource reader.Mr Shaw

The expression is part of the package variable. Click on the variable, then hit F4 which will take you to the Properties Page Window in which you access its expression property by clicking on the elipsses button. Design the expression in the editor.Arthur My Blog

The expression is part of the package variable. Click on the variable, then hit F4 which will take you to the Properties Page Window in which you access its expression property by clicking on the elipsses button. Design the expression in the editor. Arthur My Blog I have 15 properties no of which are called expression like other SSIS tasks.Mr Shaw

In each Create a SSIS variable to hold the query; set the EvaluateAsExpression property of the variable to true and provide an expression to build the query. Then in control flow; select the dataflow that contains the datareader; go to properties and select the Expressions property. There, you can assign the sql statemnt of the data reader via expression; then you just have to create an expression that points to the variable that hold the query.Arthur My Blog

In each Create a SSIS variable to hold the query; set the EvaluateAsExpression property of the variable to true and provide an expression to build the query. Then in control flow; select the dataflow that contains the datareader; go to properties and select the Expressions property. There, you can assign the sql statemnt of the data reader via expression; then you just have to create an expression that points to the variable that hold the query. Arthur My Blog Nope. I can not see any expression property. I have used this approach with other tasks and I am suprised I can not see it here. I am using sql 2005 does that make a difference?Mr Shaw

go to variable window. create a variable at the time when the variable is selected press the F4 key to go to properties window. then you will see the expression property there. also note that you should set EvaluateAsExpression property of variable to true.http://www.rad.pasfu.com

The posts are trying to get you to set an expression on an SSIS variable. You seem to want to place an expression on some Source component properties. Components in the data flow don't have properties you can mess with like other objects. You have to either set expressions on the Data Flow Task itself (out in the control flow) or do the equivalent by selecting the Data Flow background (not a specific component) and going to the properties window. Talk to me now on