I am using an OLE DB Source with SQL command for the data access mode. I defined parameters, then added a complex query with subqueries. It seems like the parameters for a query are not being filled correctly (because I am getting too many rows returned). At one point I saw an error message the said something to the effect that the parameters would be ignored when there was a subquery in the SQL.
Can anyone shed some light on this?
Thanks,
Laurence
I don't know if that is true or not but regardless of that you should stop using parameters as explained here: http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx
-Jamie
|||Jamie,
I have read your blog many times and it is really helpful. Thanks.
In this instance, the query is long and complex, and I might as well go to a script task as a string variable.
I am disappointed that parameters do not seem to be working correctly, thereby making my life more difficult.
Laurence
|||Yeah, script task is a good option in those circumstances.
N.B. SP1 will have an expression builder attached to variables which will make it easier to build your expressions.
-Jamie
|||Would you mind sharing the long, complex query that didnt work for you?
No comments:
Post a Comment