Am I missing something? The BOL doc seems to imply that the DTS read file
transform will read a file name from a source column and direct that file's
contents to a specified destination column via what I would assume to be an
UDPATE, not an INSERT. I have a table that contains the source file name and
an empty destination column, plus it contains additional fields, some with
NOT NULL constraints. When I use a Read file transform, DTS errors out with
a violation of the NOT NULL constraint. But if all it's doing is updating
the destination column, why would it give that error?