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?
The 3 errors are all the same, but with different columns having problems...
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 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
If I can fix this, I have successfully transfered my mySQL database to my SQL Server database!
For table 'Users_Misc'
user_id | autonumber
pets | text
reasons_nbti | text
Values for ALL 114 rows: