I am importing data into a decimal field using sql 2000 dts. The issue I
have is that if the first row of data is an integer and shows no decimal
point or places (as this system seems to), sql then treats all subsequent
rows as integers even if they do have decimals. There does not seem to be
any way round this on the system I am exporting from.

Does anyone know a way of making this work on a dts import?

Thanks

Brett.

Hi
Force it to place as a decimal in the DTS package. Use the Query option and
write the query as CAST (<column name>, number(5,2))

hope this will solve your purpose


--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---------------------------------------



"Brett Martin" wrote:

Thanks for the reply, but I am a novice in this area and I am not really sure
what you mean, on transform data task properties, I have selected sql query,
then pressed build query and entered the following, which gives me an
undefined function 'Cast' error.

SELECT {fn cast(ToInvGBPValue as decimal(10,2))}
FROM `orders.txt`

The following works in query builder:

use cfs
select cast(ToInvGBPValue as decimal(10,2))
from orders

Thanks

Brett.

"Chandra" wrote: