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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy