Errors while loading the sequential files to sql server

[vsi]

Hi Folks

Please help us resolving the following issue.

We are getting errors while loading the sequential files to sql server

Source:
Sequential File varying columns hold 3 different types of metadata. Delimiter is a Pipe. We are getting warning messages on particular records. We created a reject link to store rejected data.

The errors from the Director Log. Import warnings at record. The following is the warning

Import error at record and no default value. data <empty>
Field011 has import error and has no default value.

In addition to that we tried to put the default values for all null fields.

We are able to view the data in the file at the squential source stage but when we run the job it aborts due to the above errors.

Thanks in advance.

[samsuf2002]

check the data types ......as u have a reject link all the records rejected with this warning should be collected by this reject link try to analyze the data in ur reject file .

[pukars4u]

check weather there are '|' in the record.make sure your record dont have any'|' with in the record excluding the delimiters

[vsi]

check weather there are '|' in the record.make sure your record dont have any'|' with in the record excluding the delimiters

Can you explain more about how to search the delimiter in the record?

The file has pipe delimited records and there are no header columns.

Thanks.

[samsuf2002]

where r u storing the rejected records?

[vsi]

I am storing the rejected records in sequential file , but the job is not able to handle to capture the rejected records. it is giving different errors.

Thanks in advance.

[samsuf2002]

what is the log u r getting for this error ? what u mentioned above is a warning .is ur job getting aborted or just rejecting some records

[vsi]

what is the log u r getting for this error ? what u mentioned above is a warning .is ur job getting aborted or just rejecting some records

Delimiter for field "LAST_ACTV_SIGNON_ID" not found; input: {0d}, at
offset: 100

Field "DUPL_CHECK_DUR_HRS" has import error and no default value: data <empty>, at offset: 285

These are the errors/warning we are getting at job gets aborted.

Pls. try to helpo me figure out this errors.

Thanks.

[samsuf2002]

it shows that u have a pipe in ur data which is taken as delimiter by datastage creating a new column which doesnot exist ....u need need to figure out which field has data which contain pipe .......what i wud do is create a small job seq file1----Transformer-----seqfile2 and put a seqfile3 to seqfile1 as a reject link where u can capture the bad records and analyse it.....