SSIS and 'Cannot insert the value NULL into column 'myField''
- From: "larry" <larry.laffer@xxxxxxxx>
- Date: 19 Mar 2006 14:30:04 -0800
*simple problem and newbie has no clue..* ;-)
I have to copy data from one sql server table into another sql server
table. I'm using SSIS for the first time...
I'm using a simple data type conversion to move the data from one table
into another and this works fine for some tables. In another table, I
get the error:
"Cannot insert the value NULL into column 'myField', table
'ISCTest.dbo.tblmyTableXY'; column does not allow nulls. INSERT fails."
This sounds really reasonable to me, because there is a field 'myField'
in the destination table which really does not allow NULLs and there is
no such field in the source table. I would just like to give a static
value (='1') into this field, but I really can't figure out how. I
tried to set a variable, but I don't know how to assign the value of
the variable to this field...
Any hints are greatly appreciated!
.
- Follow-Ups:
- Re: SSIS and 'Cannot insert the value NULL into column 'myField''
- From: Allan Mitchell
- Re: SSIS and 'Cannot insert the value NULL into column 'myField''
- Prev by Date: Re: Embedded SSIS in applications / Deployment
- Next by Date: Re: Copy database with identity columns (SQL 2005)
- Previous by thread: Re: Conditional email
- Next by thread: Re: SSIS and 'Cannot insert the value NULL into column 'myField''
- Index(es):
Relevant Pages
|
