May 25, 2009 at 9:06 am
Hi all,
i have some data which has null value in flat file.i have to insert those in to table.
i m using multicast component. then i use script component for selected data into OLEDB destination. i m using stored procedure in that.
Problem is : when the data is null, stored procedure will not execute. i got error. if i remove the null value column , then it will work , but i have to insert the null value also .
how to handle this ?
May 25, 2009 at 9:15 am
Is the column into which you wish to insert a null value actually nullable?
What is the structure of the table? can you post the associated CREATE TABLE command?
May 25, 2009 at 9:41 am
hi,
yes, it s nullable column ..
May 25, 2009 at 9:45 am
What type is the data column, perhaps it is a non-nullable type for the means by which you are getting data into database?
May 25, 2009 at 9:52 am
hi,
if it s string variable with null values, i wont get error, it is executing.
if i use other data type ( datatime, int) then i got error
May 26, 2009 at 3:14 pm
In the flat file souce - check the following checkbox
Retain null values from the source as null values in the data flow
I haven't tried myself but give it a try and see if that resolves your issue.
~Mukti
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply