DSXchange

Hi All,

I am passing a Comma Separated File as my Input to a sequential file. In the properties, I am enabled the "Reject Property = Output".

My Input Data:
Col1(Not Nullable), Col2(Not Nullable), Col3 (Nullable)
,a,b
,,c
a,b,c
a,,c

When I am running the job instead of rejecting 3 records, it is treating as the valid records.

Could you please let me know, if I am missing anything.

The reject link will catch more severe metadata mismatches, such as records that are missing columns.

In your example, the job will most likely take your empty strings as empty strings, which are different than the NULL value. In some cases, the job will substitute in the default value for the column.

Assuming that all three columns are defined as VarChar, there is nothing wrong with your data from a metadata perspective.

Thanks Ray and qt_ky for the prompt replies.