-
SQL Server/Oracle data load-SQL loader
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|