Sunday, March 11, 2012

cannot merge after triming the key values

Hi,

I am new to SSIS.I am doing a left outer jon using the merge join.The output was wrong.I realised that may be we have to trim the key values.But when i do the trim in the derived column,the output of the derived columns shows that issorted is becoming false and the sort key position has become 0.So the merge join is showing error.How can i solve this error.

Please help.

TRIM would reset the isSorted property because removing leading and trailing spaces affects the sort order. " B" will sort ahead of "A", because of the leading space. If you are querying from a relational DB, I'd recommend doing the TRIM and SORT in your source query, and set the isSorted and SortKey properties in the Advanced Editor of the OLE DB Source. If it's not a relational source, just add a sort transform after your derived column, but before the merge join.

No comments:

Post a Comment