Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to load image column from sql server to oracle with informatica

Status
Not open for further replies.

vegisri

Technical User
Dec 16, 2002
3
IN
Hi;
any one can help me how to load the image datatype column from sqlserver 2000 to oracle 8.1.7 via informatica 4.7?
Also please let me know how to load these unsupported datatypes from one database to another?

regards
vegisri
 
*
Did you get any solution for this problem
I also tried to move an image column from SQL Server. It came up with an error.
SQL Server Message 4004 : Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.

Then I tried CONVERT function in SQL Override. No use. If you have found a solution, please post here.
*
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top