I have a data pump task in which I am pulling data from Oracle to SQL Server,
so hopefully somebody in here can help me out.

The data pump task is running a query against an Oracle table and then
copying the data straight into a SQL Server table. If I run in on our
development server everything works fine. If I run it on our test server I
am getting this error

ORA-01406: fetched column value was truncated

The structure of the destination table on both servers is exactly the same.
The only difference is the server. Can anybody help me out?

Thanks

same version and settings for Oracle Cleint on machines ?

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

I believe the server that it does work on is running Oracle 9i and the server
it fails on is running 10g. The thing that confuses me though is that I have
9 data pump tasks and only 1 has an issue, the other 8 work with no problems.

"David J. Cartwright" wrote:

again check the datatype.This prob is probaly due to the size .for example
suppose u r taking varchar(10) in ur source table and in destination u r
taking it varchar(5) than it can truncate some of the data.See the type is
same but memory u have allocated in the destination is less probly dats y its
truncating it..

Thanks
Nidhi

"Andy" wrote:

Concerned to SQL server 2000, you are using Varchar data type?

If yes, suppose you declared varchar 8000 for one field and another field 200,
It woun't allow 8200 character, because maximum capacity is not standared,
It may be 7800/8000 dipends on version,h/w config, database design.
Regards,
Rajesh

"Nidhi" wrote: