Shouldn't This Be Simple? Sybase To Oracle Data Transfer Task

I'd like to transfer some records between the following 2 tables. Surely this should be a no-brainer - what am i missing that is making this so impenetrable?

I am currently: Hoping someone can help me get here: (this is my first time of using SSIS btw).



here is the source table (MS Sql Server 2005, SP 2)



CREATE TABLE [dbo].[imagine_divs](

[div_mnemonic] [nvarchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[div_date] [int] NULL,

[div_amount] [float] NULL,

[div_status] [nvarchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[div_curr_mnem] [nvarchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[div_upd_date] [int] NULL,

[div_payment_date] [int] NULL

) ON [PRIMARY]



here is the target table (Oracle 9i)



CREATE TABLE myschema.imagine_divs

(div_mnemonic NVARCHAR2(11),

div_date NUMBER(*,0),

div_amount NUMBER(20,5),

div_status NVARCHAR2(16),

div_curr_mnem NVARCHAR2(11),

div_upd_date NUMBER(*,0),

div_payment_date NUMBER(*,0))

/



I used the SSIS Import and Export wizard to copy data between the two tables, and attempted to execute it. I use Sql Native Provider on source, and Native Ole DBOracle Provider for OLEDB. however, I get an error:



[Destination - IMAGINE_DIVS [37]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-12571: TNSacket writer failure".



I notice that the wizard has created a data flow task with 3 steps: source - imagine_divs, Destination - IMAGINE_DIVS and "data conversion 1".



Data Conversion 1 seems to be taking my source nvarchar columns and converting them to DT_STR with twice the size (for example div_mnemonic become DT_STR, size: 22).



If I change the mappings in the OLE DB Destination Editor, such that only the numeric and date-typed columns are included in the transfer, it works fine.



If I include any string-typed column in the destination editor mappings, I get the TNS Packet Writer error. If I remove the Data Conversion step and connection teh source and destination tasks directly, i get validation errors saying that:



Error 2 Validation error. Data Flow Task: OLE DB Destination [294]: Columns "div_mnemonic" and "DIV_MNEMONIC" cannot convert between unicode and non-unicode string data types. Package4.dtsx 0 0


this is despite the fact that everything is unicode here (right?)



what in the world is going on?