Page 1 of 1
Trying to insert Black where columb datatype is Date
Posted: Tue Dec 16, 2008 5:53 am
by mshilpa
Hi ALL,
I am trying to insert "Blank" in one of my column where my column data type is DATE.
But but i am not able to do so.
Could anybody please help me.
Thanks in Advance
Posted: Tue Dec 16, 2008 7:10 am
by DS_SUPPORT
What do you meant by 'BLANK'? Is it Null or Empty String ?
Will your target accept NULL values for that date column, in that case use @NULL in your Transformer derivation.
Re: Trying to insert Black where columb datatype is Date
Posted: Tue Dec 16, 2008 7:17 am
by Sathishkumarins
mshilpa wrote:
I am trying to insert "Blank" in one of my column where my column data type is DATE.
If you are using any database like oracle then you have to give 'Y' in nullable column in table or view as well as in DS. Otherwise you might get "cannot insert null error".
Posted: Tue Dec 16, 2008 12:16 pm
by ray.wurlod
If this is a parallel job (as marked) then "blank" is not a legal value. Parallel jobs strictly enforce data type compliance.