October 2010 Entries

How to Convert a DDMONYYYY Date to an ISO Date in SSIS

I had another fun day at the SSIS MSDN Forum today. It came to my attention that many people come with date-time formatting and conversion issues. Indeed, there are not so many reference articles around and a myriad of date formats out there. One of the interesting topics today was on DDMONYYYY date conversion. Most answerers suggested to use the Script Task to manipulate on dates, but I was not satisfied with the “only” answer. So, even though I like the power of the script, I was thinking there ......