sql server integration service get two digit month

RIGHT(“0” + (DT_STR,4,1252) DatePart(“yyyy”,getdate()),2) +

Right(“0” + (DT_STR,4,1252) DatePart(“m”,getdate()),2) +

Right(“0” + (DT_STR,4,1252) DatePart(“d”,getdate()),2)

http://blog.boxedbits.com/archives/34
 http://technet.microsoft.com/en-us/library/ms140216.aspx

as the pic above indicated, the red-squared part are ignored.

they are just validated to be skipped.

tip:

variable name : 
@[User::variablename]
(DT_WSTR,WIDTH) @[User::variablename]

oracle  to_char compares with SSIS string 

to test if a table exist in SSIS, just use constraint success or fail to guide the flow.