Error - BLOB data

[SubKamran]

I'm almost at the virge of importing my mySQL tables to my SQL Server, but I get 3 errors...all the same.

What is this?

Cannot instantiate Storage Object for source column 3 ('pets') Blob data.
Multiple step OLE DB operation generated errors. Check each OLE DB Status value, if available. No work was done.

The 3 errors are all the same, but with different columns having problems...

The row for that specific one is EMPTY, and it's field type is 'text,' there are about 114 rows with the same value (i.e. nothing). It's an empty table except for the blank rows. Only the 'id' field is filled in for each

In detail:

For table 'Users_Misc'

Fields:

user_id      | autonumber
pets         | text
reasons_nbti | text
***Some others***

Values for ALL 114 rows:

*auto_id*
NULL
NULL
Etc Etc

If I can fix this, I have successfully transfered my mySQL database to my SQL Server database!

[SubKamran]

I still can't figure it out...I turned on 'NULL' but it doesn't make a difference...

I don't really even know what the error means...how come it doesn't do it to every field that has a data type of 'TEXT'?