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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed