Hint: rewrite select * to the actual field names.

If you have access to oracle support checkout note 1132253.1

OPD.NET xcopy deployment

You should not set the NLS_LANG to AL32UTF8 if the client (SQLSERVER varchar) isn't AL32UTF8 aware.

Found a post that fixed this issue in SSIS apparently

Almost certain, AL32UTF8 is an unicode characterset. All char/varchar2/... columns can now store unicode characters. You can consider them nchar/nvarchar... by now.

WE8ISO8859P1 is non-unicode.

Because not all characters from AL32UTF8 can...

Unlikely that the move to 64-bit triggers cannot convert between non-unicode to unicode.

Did you change the nls_characterset of your oracle database whilst migrating from 9 to 11?

The oracle client on...

Have a search on fetch on this forum. The oracle default fetchsize is around 200.

Solved post

What do you get if you use the Oracle OLEDB drivers for oracle?

Try the oracle drivers instead of microsoft driver for oracle

Glad you sniffed it out.

Check if you have still remains of oracle software (check registry local machine\software\oracle). If I'm not mistaken the .1 points at home1.

Install 64-bit first (full administrator) and then 32-bit in...

Did you install them in a different base directory? 11g has a deinstall bug

Any errors in the install log?

Smallint can be used to store 0 or 1, but isn't supported in Oracle (has number datatype).

ANSI<->TSQL

ANSI<->Oracle

Congratulations

You'll have to specify nogrowth for the datafile like (no autoextend clause)

Like

CREATE TEMPORARY TABLESPACE temp TEMPFILE 'd:\temp\tempfile1.dbf' SIZE 4096M ;

It pays to read the oracle concepts

Oracle concepts

Administrator guide on oracle...