Detailed information about Microsoft SQL Server Data Types and its mapping to another databases ... varbinary, and image data types is the number of bytes. For example, an int data type can hold 10 ...

The following screen shot shows an example of the Review Data Type Mapping page of the wizard.. In this example: The user has specified a mapping in the Column Mappings dialog box that may not succeed ...

What version of SQL server are you using? The current version says that it support BLOB's, but honestly I have not used this data type. The Microsoft KB (knowledge base) may be a good starting ...

This option allows the storage of SQL Server BLOB data externally on the file system with synchronized, durable transaction processing and full recovery options.