Yep this works. It also works in the DTS query to pull the data. But it should be

CONVERT(char(8), DateColumn, 112) instead of char(10) yyyymmdd is 8 chars.