Currently i have to make query dynamic, i have to pass date variable to query to execute for specific date range, and this date range could be very time by time, Previously I tried for script component or expression of variable to build query but failed, but then I found command option of oledb command. I placed query there with “?” sign at places where my parameter will replace the date value . Consider following
When I passed query there Parameter button on wizard activate. I set there variable to parameter .
This approach is work fine for me, but if you have places are more then 3 to 4 , query parsing failed. so you have to write query in such a way that minimum number of places parameter are used.