I have imported data through dts. But when viewing the data it is rounding.

eg 0.10 is imported as 0

What has happened with the import.

Can you show us the Source table definition and the destination table
defintion.

Looks like datatype mismatches may be occuring


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"shane" <anonymous (AT) discussions (DOT) microsoft.com> wrote