System.Exception: XML parsing: line 1, character 22466, illegal xml character

[TheGongoDev82]

Hi,

I'm trying to use your SP.

I installed it as requested on the master database.

The statement I'm running is

USE master;
GO

EXEC [MyDB]..[sp_generate_merge] @table_name='MyTable', @schema='dbo', @nologo=1, @include_use_db=0, @delete_if_not_matched=0

I get this error:

Msg 9420, Level 16, State 1, Procedure MyDB..sp_generate_merge, Line 753 [Batch Start Line 4]
XML parsing: line 1, character 22466, illegal xml character

I noticed that one of the fields in the first row of MyTable contains this character '/'. The field is a

[varchar](250) NOT NULL.

Can you help me to solve this problem?

[dnlnln]

That's strange, unfortunately I was unable to reproduce this. Would you mind providing DDL & DMR to help me repro this, and also could you please include in the T-SQL the column collations if your DB uses a collation other than SQL_Latin1_General_CP1_CI_AS.