Read it at this link http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspxthat selection from dropdown is equal to Select * . I agree but how do you not select AS400 library from dropdown? Also i have not see any other place to supply a query other than Execute Sql task .
kushpaw
kushpaw wrote:
Read it at this link http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspxthat selection from dropdown is equal to Select * .
Actually, the point of that blog post was that they are NOT the same.
I agree but how do you not select AS400 library from dropdown? Also i have not see any other place to supply a query other than Execute Sql task .
kushpaw
In the OLE DB Source you have to choose whether to simply pick a table or supply a query.
-Jamie
|||
Jamie, i was looking for some way if query could be done in a db2 connection and avoid dropdown. Even for sql connection where would you write the query, in a script because i didnot see any such option in propery page or edit option dialog. If you could suggest any link?
many thnx,
kushpaw
|||Jamie, i was looking for some way if query could be done in a db2 connection and avoid dropdown. Even for sql connection where would you write the query, in a script because i didnot see any such option in propery page or edit option dialog. If you could suggest any link?
many thnx,
kushpaw
Have you even bothered to look?
Select "SQL Command" from the 'Data Access Mode' dropdown in the OLE DB Source.
-Jamie
No comments:
Post a Comment