How could I specify in either FF Connection manager or source that it shouldnt give any error and assume blank or no value as NULL ?Thanks,Fahad

You can't. There is no such thing in a flat file. You'll have to bring in your empty field and then use a derived column to set it to NULL, if necessary.

Can I change type in derived column ?I am able to get the field in STR column, Now I wanna change the type of it. Can I ?

Fahad349 wrote:Can I change type in derived column ?I am able to get the field in STR column, Now I wanna change the type of it. Can I ?You can do all of this in a derived column. You can't change the type of a column in the dataflow, but you can CAST it to a new type in a NEW column.

Ok, Last thing is, the source feed contains spaces instead of no value between 2 commas, and I think this makes FF Source failed, what do you think ?

Import as string, then you can TRIM() that field later in a derived column.

you can go to the properties of the Flat file source and set 'RetainNulls' to 'True'. I think that solves your problem.

Saurabh Kulkarni wrote:you can go to the properties of the Flat file source and set 'RetainNulls' to 'True'. I think that solves your problem.Except the OP stated that the value was blank or empty, not null (char(0)).

Thanks Saurabh It worked...