problem in importing oracle database into sql database

[rohitsingh0000]

hi,
i want to import the tables of a oracle database into the sql database.but i am getting errors importing some tables with certain coulms.so far as i got the problem is that a column named D_O_B in the oracle database table having datatype date ,while its creating problem transfoming in to datetime in sql,as there is not any other type for dates.so plss help me,as i cant understand this problem.The error is ilke this---

Error at destination at row no 9857.Errors encountered so far in the task:1,
Insert error,column 22 (B_O_B, DBTYPE_DBTIMESTAMP),status 6:data over flow.Invalid character for cast specification.

[rohitsingh0000]

Hi
i want to import the tables from oracle databse to sql databse through c# application.Plls give me the code as how should i proceed to import the tables from oracle to sql.