Hi

I'm using SSIS to bring data from one SQL 2005 db table to another.  They
both have SP2 installed.  The destination table has six nvarchar(max) fields
which are converted from nvarchar(4000).  When I run the package in debug
mode I get the following error:  "Expected the TEXT token in data stream for
bulk copy of text or image data."  This even happens when I comment out those
six (nullable) fields and just try bringing over the other fields.  Anyone
have any clues to help fix this?

In case someone else runs into this issue...

I finally figured this out.  The destination table contained a computed
field which I dropped, successfully imported the data, and recreated.

A day's worth of pulling out my hair has paid off.  Learn from me and always
check the little things.