Tried a few things - first I noticed the TEXTIMAGE_ON [PRIMARY] within the PK constraint in the DDL. Since there was no text image, I removed that and tried...

I just tried this:

Created a new table named MTSA_Data2 at both the source and destination databases. Changed the TEXT datatype to VARCHAR(MAX) on both. I left off the...

I just tried to guage the length of the text fields with len(cast(special_instructions_tx as varchar(max)))

Some lengths returned were > 35K

I thought it was the TEXT column too, but there's another table in this DB that has 5 TEXT columns and it doesn't seem to have a problem. It...

Here it is (there are no triggers on the table):

CREATE TABLE [dbo].[MTSA_Data](

[mtsa_id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[ssn_id] [char](9) NOT NULL,

[uic_cd] [varchar](6) NULL,

[uic_tx] [varchar](100) NULL,

[pers_cntrl_nbr_id] [char](10) NULL,

[report_dt] [smalldatetime] NULL,

[special_instructions_tx]...