Migration from SQL Server to Oracle

[niranjan76]

Hello,

I am migrating data from SQL server 7 to Oracle 8i.
I am using Microsoft Data Transformation service.

In SQl server I have tables with fields having datatype
text(16)
varchar(7500)

The target fields in Oracle is Long data type.

By default the DTS truncates the fields to 80 char when i do this migration.

Is there any way I can do this Migration without truncation....

Thanks,
Niranjan

 

[sem]

Unfortunately I've never used DTS. Though the default length for displaying long field in sql*plus is also 80 (standard screen size). It may be overrided by
set long <longlength>
Maybe DTS also contains some similar command...