Hi all,
I am importing a DB2 table using DTS to a SQL server 2K5.
The problem is DB2 timestamp is 10 bytes and sql datetime is still 8 bytes.
what are my options if i don't want to loose the precision?
Have any body tried this before? Please comment
I think of following possibilities:
1. varchar(26) : I've already have thought about and ruled this one out.
2. split this data into a SQL date (datetime) and another column storing
just the microsecond part (int)
3. Create a udf and store the data as bigint?
Which one is the best approach and why? any other ideas?

Thanks in advance!
Utpal