Hi devilsid,

thanks for your comment.

There is no particular reason I want that particular formatting, as long as they all values are consistently formatted I caan live with that.

When you say use a normal data conversion to convert it to a date,

do you mean within the ssis process prior to the data landing in the database table or after the data is in the table?