SQL IMport Error -- Help Please

Hi, trying to import data from a MySQL DB to MSSQL 2005. Having some errors with collating it looks like. Maybe the syntax is incorrect...not sure. Never imported this way.

here is the import to create a table.

SET AUTOCOMMIT=0;
START TRANSACTION;

CREATE TABLE "tbl3215" (
"id" int(11) NOT NULL,
"IttNumber" text collate latin1_general_ci NOT NULL,
"IttTitle" text collate latin1_general_ci NOT NULL,
"IttDescription" text collate latin1_general_ci NOT NULL,
"IttJustification" text collate latin1_general_ci NOT NULL,
"TechSolution" text collate latin1_general_ci NOT NULL,
"DateReceived" text collate latin1_general_ci NOT NULL,
"DateRequired" text collate latin1_general_ci NOT NULL,
"Customer" text collate latin1_general_ci NOT NULL,
"OrgID" text collate latin1_general_ci NOT NULL,
"Funded" text collate latin1_general_ci NOT NULL,
"HBApID" text collate latin1_general_ci NOT NULL,
"Disapproved" text collate latin1_general_ci NOT NULL,
"DisReason" text collate latin1_general_ci NOT NULL,
"Completed" text collate latin1_general_ci NOT NULL,
"CompletionDate" text collate latin1_general_ci NOT NULL,
"Priority" text collate latin1_general_ci NOT NULL,
PRIMARY KEY ("id")
) AUTO_INCREMENT=4735 ;

here is the error returned.

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.
Msg 448, Level 16, State 2, Line 6
Invalid collation 'latin1_general_ci'.
Msg 448, Level 16, State 2, Line 7
Invalid collation 'latin1_general_ci'.
Msg 448, Level 16, State 2, Line 8
Invalid collation 'latin1_general_ci'.
Msg 448, Level 16, State 2, Line 9
Invalid collation 'latin1_general_ci'.
etc...

Now, i am not sure how to make this work, i am thinking sql2005 may not recognize latin1_general_ci? Is there a quide to which databases use which character sets and their incompatibilities?

Any help appreciated

Joe