I have created a DTS importing 3 columns to a table. One
of them is a key. However, when I execute the DTS, I get
the error message saying that another field (that is not a
key) that I do not suppose to update:

Cannot insert the value NULL into column 'abc'

Is there any suggestion ?

In article <2cef001c4694b$1588b140$a301280a (AT) phx (DOT) gbl>, Peter wrote:
It sounds as though attribute abc is non-nullable. By entering values
into the other attributes and not this you are forcing NULL because it
looks as though there is also no default defined.




Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Yes, it is non-nullable field.

However, I have to update the other columns and don't want
to touch it.

In this way, what should I do ? Thanking you in
anticipation.