I can't seem to figure out how to use the SSIS Expression syntax to ensure that the date is 8 digits for use in my file name (ex. 1333_Book2Book_20100129.txt). The below only gets me 2010129.txt.
(DT_WSTR, 4) YEAR (GetDate() ) + (DT_WSTR, 2) Month (GetDate() ) + (DT_WSTR, 2) Day(GetDate() )
I have a function that I can call in SQL task to get a date in the right format, but I can't figure out how to save it to a variable. I get an error with types mismatches. I cast the value as varchar(8) and the variable is a string.
Any help would be much appreciated.