Msg 156, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'IF'.
Msg 102, Level 15, State 1, Line 27
Incorrect syntax near 'adodb_logsql'.
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'mdl_assignment'.
Msg 102, Level 15, State 1, Line 308
Incorrect syntax near 'mdl_assignment_submissions'.
Msg 105, Level 15, State 1, Line 866
Unclosed quotation mark after the character string '<table class="MsoNormalTable" style="border-right: medium none; border-top: medium none; margin: auto auto auto 5.4pt; border-left: medium none; border-bottom: medium none; ...
Here is a straight forward guide from a reliable source.... non SSIS method...
http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx
SQL Server White Papers: Guides to Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server 2005
http://www.microsoft.com/downloads/details.aspx?FamilyID=3f0f2a3f-dff9-49cd-8ea7-581aa7a303a4&displaylang=en
hope it helps...