Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  transfer numeric fr SQL Svr to AS400 Db2

Author  Topic  starwang Starting Member 1 Post Posted - 2005-09-02 : 12:44:43 Hi, I need to transfer data from a SQL Server 7.0 table to a AS400 DB2 table. I use the DTS Export wizard and am having difficulty with numeric fields. The table contains some numeric fields and some varchar fields. For numeric fields,data type was "numeric" both in the SQL server table and DB2 table. After running DTS (copy table), all the varchar fields were with correct data, while all the numeric fileds were only with the default value 0. For the numeric fields, I then changed SQL Server table data types to int, varchar, sql_variant and money and re-run DTS. The results remain the same I am not supposed to change the DB2 table definition. How to get the numeric values properly tranferred? Any advice? Thanks a lot!