*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!

Hello Larry,

Have a look at the derived column transform. You can do what you want in
there.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com