Re: DTS question for sql server
- From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@xxxxxxxxxx>
- Date: Fri, 12 Jan 2007 08:04:42 +0100
X The number of failing rows exceeds the maximum specified.
TransformCopy 'DTSTransformation_1'conversion error: Destination does not
allow NULL on column pair 1 (source xxxxx, destination xxxxxx)
Obviously, you have unknown (NULL) values in source column, and your
destination column does not allow NULL values. You can alter the destination
table and allow NULL values in your destination column, or you can use the
ISNULL function in the source query to change the NULL value from the source
to some predefined value.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
.
- Prev by Date: Re: Transaction and locks
- Next by Date: Alter command in SP
- Previous by thread: Transaction and locks
- Next by thread: Alter command in SP
- Index(es):
Relevant Pages
|
Loading
