Skip to Content

Match Transform in BODS 4.2

Mar 08, 2017 at 02:53 PM


avatar image
Former Member

We have Polish language dataset that needs to be matched with another Polish language dataset. Can I use Match Transform to find the duplicates? I have used Match Transform in similar cases successfully but in those projects source and target were all in English.

Would greatly appreciate if someone can clarify on this issue.

Thanks in advance!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Brandon Jacobson
Mar 09, 2017 at 03:33 PM


Yes, you can use Match with more than English and Latin1 data. See KBA 1537235 for information about the Match Engine option.

There is additional information on this in the Data Services Designer Guide.


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your answer Brandon.

I am importing Polish language dataset into SQL Server 2012 using BODS 4.2 and I have noticed that some of the Polish characters are changed - For example TORUŃ is changed in table to TORU.

When I import same Excel file directly to SQL Server using management studio then everything imports without issues.

Should I do anything differently when I am importing data using BODS 4.2? Your suggestions are greatly appreciated.