DSXchange

While loading large amount of data using ODBC it is slow,
is there any other alternative way to load data very fastly if there is any long Varchar field, because if we increase the transactuion size for the table having long varchar we are getting error while loading. the error is:

Abnormal termination..................is there any solution for this.......to load data in effective way

If you are using oracle then use a primary key index and if possible add a parallel hint to your query. So that you no need to change your DS code.

A LongVarchar field would imply a LOB field of some time in the source and, if that's the case, there really isn't a good way to "load data very fastly".