DTS loads incorrect data

[naga5566]

Hi All,

We are facing a strange problem with one of our DTS package on production.

WE load a table from Informix to SQl server2000 on daily basis.
In the source ,there is decmial column "income".When we load it in the target Sql server ,it loads incorrect data.
For example .Sorece has column A (primary key),Income and the same in target.
Source colums has values like
Col A, COl Income
Abc 100.00
Def 45.52
Xyz 78.52

When the above values are loaded in the target,the rows which are multiple if 10's get corrupt and are loaded as 1.00 for 100.00 .If the source has 180.00 ,it is loaded as 18.00.However the DTS pacakage loads correctly on devlopment server and causing this issue only on production box.Can anyone has any idea as to why this happens would be greatly appreciated.

Thanks
Naga.

 

[dbomrrsm]

what data type and precision etc is the column the amounts are loaded into on the development server and the production one ?

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[naga5566]

It is as Decimal(8,2) in source(Informix) , Dev and prod.
WE also tried to replace the DTS package with its copy thinking that the pacakage may be corrupt on server.But no use.

 

[dbomrrsm]

what are the types etc on the SQL Server dev and prod boxes ?

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[yksvaan]

Is your transfotrmation Copy Column or ActiveX, and if latter, what does it look like ?

Are the International settings same in dev and prod servers? And what about Informix drivers and their settings?

Cheers


[blue]Backup system is as good as the latest recovery[/blue]