Link to home
Create AccountLog in
Avatar of DDB
DDBFlag for United States of America

asked on

SSIS - import data from MySql to Sql Server 2008

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[16]]: the input column "xx" (61) has an unsupported datatype. it must be DT_STR,ST_wSTr,DT_text, or dt_Ntext.  Appreciate your help.
ASKER CERTIFIED SOLUTION
Avatar of Wizilling
Wizilling
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of DDB

ASKER

thank you so much, it worked !  i have another qustion if you don't mind. I have about 100 tables that I need to import. Do you think it's appropriate to put all of them into one package? or it's beter to split them into several packages?
several packages will be hard to execute.
option 1  One package but several data flow task,

option 2. one package and one data flow task and 100 tables in 1 data flow task

I would recommend option 1.


Thanks for the points
Avatar of DDB

ASKER

thank you!