• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1198
  • Last Modified:

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.
0
DDB
Asked:
DDB
  • 2
  • 2
1 Solution
 
WizillingCommented:
pls try adding a data conversion or derived column task and change the data type to DT_STR
0
 
DDBAuthor Commented:
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?
0
 
WizillingCommented:
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
0
 
DDBAuthor Commented:
thank you!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now