InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 09:37:59 GMT20http://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspx[quote][b]sqlbi.vvamsi (1/22/2013)[/b][hr]type casting that column to dt_dbtimestamp should work[/quote]Works like a charm :)thank youWed, 23 Jan 2013 01:10:48 GMTavishainhttp://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspxtype casting that column to dt_dbtimestamp should workTue, 22 Jan 2013 11:03:53 GMTsqlbi.vvamsihttp://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspxHere is expression you needed(DT_STR,4,1252)YEAR((DT_DBDATE)"January 22, 2008") + "-" + (DT_STR,2,1252)MONTH((DT_DBDATE)"January 22, 2008") + "-" + (DT_STR,2,1252)DAY((DT_DBDATE)"January 22, 2008")Tue, 22 Jan 2013 11:00:16 GMTquillis131http://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspx[quote][b]avishain (1/21/2013)[/b][hr]im developing an ssis package.while im in the sql server , there is a field that contains a text string , for example:December 13, 2008and 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)thank you[/quote]Here is expression you needed(DT_STR,4,1252)YEAR((DT_DBDATE)"January 22, 2008") + "-" + (DT_STR,2,1252)MONTH((DT_DBDATE)"January 22, 2008") + "-" + (DT_STR,2,1252)DAY((DT_DBDATE)"January 22, 2008")Tue, 22 Jan 2013 10:58:58 GMTquillis131http://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspxthe DS would be an XML file.... so i have to this within the ssis package :)Tue, 22 Jan 2013 00:30:17 GMTavishainhttp://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspx[quote][b]avishain (1/21/2013)[/b][hr]im developing an ssis package.while im in the sql server , there is a field that contains a text string , for example:December 13, 2008and 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)[/quote]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: [url]http://toddmcdermid.blogspot.com/2008/11/converting-strings-to-dates-in-derived.html#!/2008/11/converting-strings-to-dates-in-derived.html[/url]HTH,RobMon, 21 Jan 2013 13:24:46 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1409552-364-1.aspxim developing an ssis package.while im in the sql server , there is a field that contains a text string , for example:December 13, 2008and 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)thank youMon, 21 Jan 2013 07:40:48 GMTavishain