MS SQL Server DTS - Read File Transformation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Read File Transformation

BootieDay

2005-07-29, 8:24 pm

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?

Sponsored Links