I use to load data from MS-SQL server to Oracle-9i using DTS package on SQL Server.It works fine,but takes more time.

In order to reduce the load time for this tranformation,I loaded data from SQL Server to flat file using DTS package and
from flat file to Oracle using SQL Loader which is much faster than using only DTS package.In few cases it works very well .

BUT THE PROBLEM COMES in the follwoing columns :

sql server oracle
datatype datatype
---------- ----------

datetime date
money number
Int number
bit char
these columns data give the problem for ORA-01722: invalid number when I load from flat file to oracle using sqlloader.THIS PROBLEM DOES NOT COME WHEN I AM USING DTS PACKAGE.

ANY CLUE to resolve this problem...I would appreciate the help.

Thanks