I m new to SSIS and I m trying to convert a GetDate to string DD-MM-YYYY This is the expression I ve built so far DT WSTR 8 DAY GETDATE - DT WSTR 8 MONTH GETDATE - 1 - DT WSTR 8 YEAR GETDATE The problem I ve got is Month converts the Month 23-4-2013 to a single character when I want it in Double character same as day How do i make it into a double character no matter what month it is

SSIS expression: convert date to string

The Solution to SSIS expression: convert date to string is

For SSIS you could go with:

RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2) + "-" +  (DT_STR, 4, 1252) DATEPART("yy" , GETDATE())

Expression builder screen:

Expression builder screen

~ Answered on 2013-05-23 10:30:29

SSIS expression: convert date to string

The Solution to SSIS expression: convert date to string is

Most Viewed Questions: