I have a variable scoped to my package that I assigned to a sql statement. The data type is string (DT_WSTR). I need to convert that to a date time function so I can use it in a data flow task sql statement - an OLE DB data source where I want to make sure that any value returned in the data source is greater than my variable.

any help would be greatly appreciated...