In the DTS it builds a default type but on the destination tab you should be able to change to what you want. Note however, I think there is documentation somewhere that states the timestamp datatype in 6.5 is not compatible directly with the one in 7. Check BOL or MS KB Site.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply