SSIS - import data from MySql to Sql Server 2008
Posted on 2010-09-13
I am trying to import data from MySQL to SQl Server 2008 using SSIS. I added DataFlow with ADo Net source and OLE DB destination. Then I added character map. I mapped all fields accordingly. The source data has types INT unsigned and VARCHAR; the destination tables has INT type and nvarchar type. When I tried to run the package I got error for fields defined as unsigned int: error at data flow task [character Map]: the input column "xx" (61) has an unsupported datatype. it must be DT_STR,ST_wSTr,DT_text, or dt_Ntext. Appreciate your help.