Skip to Content
avatar image
Former Member

Match Transform in BODS 4.2

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 09, 2017 at 03:33 PM

    Hello,

    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.

    Best,
    Brandon

    Add comment
    10|10000 characters needed 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.

      Thanks