I converted the variable effectivedate into DT_WSTR,10 then it is working thanks

Phil Parkin (7/6/2009)

---

You probably need to use a Script task to assign the text and access the contents of the variable - otherwise you'll just get the literal text in...

Phil Parkin (7/6/2009)

---

OK, not quite correct for an OLEDB source.

First you need to assign the whole SQL string to a variable, then you need to change the Data Access Mode...

Can you please guide how can i set the expression to SQL?

Thanks.I have converted the datatype values as string in Transformation expression and populated into flat file.It is working fine.