Problem in TrimLeadingTrailing
Moderators: chulett, rschirm, roy
Problem in TrimLeadingTrailing
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is Field002 able to carry nulls? If so derive it as
Code: Select all
If IsNull(InLink.Field002) Then SetNull() Else TrimLeadingTrailing(InLink.Field002)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.