Question :
while importing data from oracle to SQL-Server 2000
using DTS in SQL Server i have done
1.checked the include Primary key in option in Column Mapping
tab page.
2.In Constraint tab page i have checked include Primary key
option

The table has been succesfully imported.I have got

1.The varchar2 data type imported as Char
2.The Primary key constraint is not transfered

Is there any solutions?


S.Sivakumar
System Analyst
Indus Cybertech Pvt. LTd.
Chennai.

MS Sql Server LazyDBA home page