Import DB2 Timestamp into SQL 2k5

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Thread Tools

Display Modes

utpal

Posts: n/a

Import DB2 Timestamp into SQL 2k5 - 10-05-2005 , 03:06 PM

hi all,
I am importing a DB2 table using DB2. 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 data? i already have thought about and ruled out varchar(26) as
my options. any other ideas?
Thanks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off