ASCII Nulls in Sequential File

arati · Post by **arati** » Tue Jun 24, 2008 6:26 am

Hi,

We are facing problem with ASCII Nulls in fixed-width sequential file. This fixed width sequential file is getting created in server job which has CHAR(20) column. In this column, sometimes data coming in is not exact 20.

This file further used in parallel job where we are converting it into dataset and this dataset is used to load table. Now in table ASCII nulls are getting inserted. Please tell me how to check and remove ascii nulls from sequential file.

Thanks.

ArndW · Post by **ArndW** » Tue Jun 24, 2008 7:16 am

To convert to "?" in a transform stage, use "CONVERT(CHAR(000),'?',In.StringColumn)"

ray.wurlod · Post by **ray.wurlod** » Tue Jun 24, 2008 4:20 pm

Change the value of APT_STRING_PADCHAR to something other than 0x00.

arati · Post by **arati** » Tue Jun 24, 2008 10:55 pm

[quote="ArndW"]To convert to "?" in a transform stage, use "CONVERT(CHAR(000),'?',In.StringColumn)" ...[/quote]

Thanks a lot ArndW.
That is working fine.