avishain (1/21/2013)
im developing an ssis package.while im in the sql server , there is a field that contains a text string , for example:
December 13, 2008
and so on...
i want to convert it to 2008-12-13 00:00:00.000 or 2008-12-13 (its same for me)
so, in the sql server i can do it with this statement:
SELECT convert(datetime,myfiled, 107)
FROM ....
the question is , what is the equivalent statement to it within the SSIS 2008 ? (with derived column)
Why not just do it in your source SQL as you described above? Or is the datasource not from SQL Server?
If not, take a look at: http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html#!/2008/11/converting-strings-to-dates-in-derived.html
HTH,
Rob