DSXchange

Well... as least we're finally at a Resolved status. Thanks for your perseverance, hopefully anyone stumbling across this same issue in SQL Server will make it all the way to the end and save themselves a lot of time.

I've stashed this away in my Favorites on the off-chance I have the... pleasure... of working with that particular database.

Here is the way I did it with ODBC Stage.

Change Datatype to VARCHAR and append the time part to it and load it as VARCHAR for insert/update and it should work.

This post was really helpful, thanks to all of you