Ah, my apologies. You said that in your original post and I was in too much of a hurry. I'm not sure how to do this on the SSIS side of the export. There should be something in SSIS that says use the result set of your proc as all text data instead of converting the text (dates) back to a datetime.
--Jeff Moden
Change is inevitable... Change for the better is not.