Problem in TrimLeadingTrailing

kondeti · Post by **kondeti** » Wed Feb 07, 2007 11:44 pm

Dear All

I am reading a file from Unix through Sequential file Stage it contian 82 columns all columns I am reading as NVarchar and Null is Yes. After that in transformer I am upplying TrimLeadingTrailing function for all the 82 columns and sending into the Target Database SQLServer 2005.

This job unable to populate the data into the Database. Sequential file stage is reading the data but transformer satage is not allowing to populate in to the target. If i remove TrimLeadingTrailing function from all the columns then it populating data in to the Target but as per the client requirement I need to implement TrimLeadingTrailing function for all the columns. please help me on this

balajisr · Post by **balajisr** » Thu Feb 08, 2007 12:00 am

Can you post any errors or warnings reported.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 08, 2007 12:06 am

Etiquette Note
When a problem is resolved, we post some information as to HOW it was resolved, the better to assist future searchers.

kondeti · Post by **kondeti** » Thu Feb 08, 2007 12:20 am

This is the warning I am getting

APT_CombinedOperatorController,0: Field 'Field002' from input dataset '0' is NULL. Record dropped.

balajisr · Post by **balajisr** » Thu Feb 08, 2007 12:28 am

kondeti wrote:This is the warning I am getting

APT_CombinedOperatorController,0: Field 'Field002' from input dataset '0' is NULL. Record dropped.

Handle Null while trimming.

kondeti · Post by **kondeti** » Thu Feb 08, 2007 12:47 am

As per the client requirement I can't handle any null values and I can't eleminate TrimLeadingandTrailing function. The same thing I Implemented in couple of jobs I didn't get this problem. Please provide your inputs.

balajisr · Post by **balajisr** » Thu Feb 08, 2007 1:00 am

If the incoming value is not null then trim the value else do not trim it.
Using TrimLeadingTrailing function on a null value will cause record to be dropped. Probably in other jobs you may not have null value coming from the source.

kumar_s · Post by **kumar_s** » Thu Feb 08, 2007 1:07 am

If input data has empty spaces, the trim function will trim it and produce null. Based on the padchar property that was set in project level.
If the table columns are not null, the data will not be inserted.

kondeti · Post by **kondeti** » Thu Feb 08, 2007 1:10 am

Thnaks for your valuable input.

kumar_s · Post by **kumar_s** » Thu Feb 08, 2007 1:15 am

As Ray mentioned, if you got your problem solved, drop a word on how you manage to do it. So that it helps the other searchers.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 08, 2007 1:46 am

Is Field002 able to carry nulls? If so derive it as

Code: Select all

If IsNull(InLink.Field002) Then SetNull() Else TrimLeadingTrailing(InLink.Field002)