If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: image datatype in SQL 2000 to varbinary(max) in SQL 2005

We used SSIS to move data from a table in SQL 2000 which had a column with the image datatype to a column in a table in SQL 2005 that has a datatype of varbinary(max). No errors were produced from the SSIS package.

There were a number of records where the DATALENGTH of the column with the image datatype was greater than 8000. Was the data truncated for these records?

This is probably a very elementary question, but I am not familiar with the application or the data.

when I hover the cursor over the storage type of varbinary under the Programmability tree in Management Studio 8000 is shown as the max length ... which is the max length if you specify a length n instead of specifying "max".