Reading fixed string and aborting

Nagasudheerkumar · Post by **Nagasudheerkumar** » Tue Oct 09, 2012 4:04 am

I have one ADDR_TYP_CD column with length of 10 i.e char(10) if iam getting more than 10 characters then the job should abort and if iam getting less than or equal to 10 characters I should read those data.
I know Varchar(10) can achieve only 2nd requirement but i have to do both.

Can anybody help me how to achieve this in sequentail file stage. This is a huge requirement for us now.

ArndW · Post by **ArndW** » Tue Oct 09, 2012 4:31 am

The goods news is that the problem can be solved, but you will need to supply more information.

Is the file that you are reading declared with fixed width or variable width? Are there column separator characters?

If there are column separator characters, then declare your field as VarChar(64) (just an example, any value will do in server jobs). Then in a transform stage simply query on "Len(In.Column) <> 10" to see if the column contains a valid number of characters or not.

Suruchi · Post by **Suruchi** » Tue Oct 09, 2012 7:59 am

Why do you want to abort the job via sequential stage?You can do the same using a transformer stage next to sequential stage.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 09, 2012 3:24 pm

Can you get a size 15 foot into a size 10 shoe? Then why do you think a requirement to store 15 characters in a Char(10) fields is legitimate?