dbTalk Databases Forums  

export table from sql 2005 to oracle 9i using SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss export table from sql 2005 to oracle 9i using SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bourg fat
 
Posts: n/a

Default export table from sql 2005 to oracle 9i using SSIS - 09-28-2006 , 09:32 AM








I try to export table with the follow structure

TABLE [Mama]
(
[ID] int NOT NULL,
[TSMKEY] nvarchar(50) NOT NULL,
[value] nvarchar(max),
[ELID] nvarchar(14),
[MAPTSMKEY] NVARCHAR(50),
IA_TSMKEYTYPE NVARCHAR(50)
)

To oracle by I have converstion unicode vs non unicode

Is some body has any idea how to solve this bug

Thanks


*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.