SSIS expression convert date to string

Question

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

User · Answer

If  like me  you are trying to use GETDATE   within an expression and have the seemingly unreasonable requirement  SSIS SSDT seems very much a work in progress to me  and not a polished offering  of wanting that date to get inserted into SQL Server as a valid date  type   datetime   then I found this expression to work     User  someVar     DT WSTR 4 YEAR GETDATE       -     RIGHT  0     DT WSTR 2 MONTH GETDATE     2     -     RIGHT  0     DT WSTR 2 DAY  GETDATE     2          RIGHT  0     DT WSTR 2 DATEPART  hh   GETDATE     2          RIGHT  0     DT WSTR 2 DATEPART  mi   GETDATE     2          RIGHT  0     DT WSTR 2 DATEPART  ss   GETDATE     2    I found this code snippet HERE

User · Answer

User  path    MDS Material    DT STR  4  1252  DATEPART  yy    GETDATE           RIGHT  0     DT STR  2  1252  DATEPART  mm    GETDATE     2          RIGHT  0     DT STR  2  1252  DATEPART  dd    GETDATE     2

User · Answer

for the sake of completeness  you could use    DT STR 8  1252   YEAR GetDate      10000   MONTH GetDate      100   DAY GetDate       for YYYYMMDD or   RIGHT  000000     DT STR 8  1252   DAY GetDate      1000000   MONTH GetDate      10000   YEAR GetDate      8    for DDMMYYYY  without hyphens   If you want   need the date as integer  e g  for  key-columns in DWHs   just remove the DT STR   RIGTH function and do just the math

User · Answer

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

User · Answer

Something simpler than what  Milen proposed but it gives YYYY-MM-DD instead of the DD-MM-YYYY you wanted    SUBSTRING  DT STR 30  1252  GETDATE    1  10    Expression builder screen

[ssis] SSIS expression: convert date to string

Examples related to ssis

Examples related to expression

Examples related to getdate