SQL command from variable in ole db source not reevaluate in foreach loop container

Question

I have a data flow task in my foreach loop container. Every round, I reassign 3 varaiables: User::Date, User::Location, and User::Organization. I have another variable User:Query that has an expression using these variables in where clause. I use this User:Query in the OLE DB Source of the data flow task, but in each foreach round, it uses the same default values for these variables. Why?

OLE DB Provider: OLE DB Provider for Analysis Services 10.0 And on break point, I can see the query variable is actually showing correct, but the source doesn't use the updated variable.

YSJ · Accepted Answer · 2016-05-12 18:13:48Z

1

Finally figured out: I didn't change EvaluateAsExpression property to True for my User::Query variable.

answered May 12, 2016 at 18:13

YSJ

3922 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL command from variable in ole db source not reevaluate in foreach loop container

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related