Can i import data via odbc to oracle 9i Express Edition via odbc ? if yes ,How?

Please Elaborate "allow_drop_ship column has the error with truncation ...so if you want to see the rows which makes you cause the error jus go to the source and click...

I can't change odbc datatypes (that is varchar2),that is not in my hand,i can do any thing with sqlserevr.

i am trying to import data with the help of these :...

Hi,

sqlserver datatype is nvarchar(max) and odbc datatype is varchar2.

Hi,

I am using sqlserver 2005 and SSIS.