• You can populate a date output parameter using the Execute SQL Task by setting the variables in the result set. The first column, Result Name, type 0 (the number zero) and the second select the variable you want to populate from the drop down list.

    I'd attach a photo but I'm having some trouble figuring out how that is done.