InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:00:18 GMT20http://www.sqlservercentral.com/Forums/Topic1424738-364-1.aspxHere's another option:[code]SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),6,2) + SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),9,2) + SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),1,4)[/code]Wed, 27 Feb 2013 15:45:49 GMTkl25http://www.sqlservercentral.com/Forums/Topic1424738-364-1.aspx[quote][b]manibad (2/27/2013)[/b][hr]I need to convert date into string literal in SSIS in derived column.How is it possible.Example:Input-2013-01-07 00:00:00.000Output-07012013Please guide me in achieving this in SSIS.Thanks in advance[/quote]Just off the top of my head, try an expression like:[code="plain"]RIGHT("0" + (DT_WSTR,2)DAY(GETDATE(),2) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE(),2) + (DT_WSTR, 4)YEAR(GETDATE())[/code]HTH,RobWed, 27 Feb 2013 15:00:48 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1424738-364-1.aspxI need to convert date into string literal in SSIS in derived column.How is it possible.Example:Input-2013-01-07 00:00:00.000Output-07012013Please guide me in achieving this in SSIS.Thanks in advanceWed, 27 Feb 2013 13:55:41 GMTmanibad