title: SQL Server Transactional replication - The process could not bulk copy into
body: <p>So I have setup T-replication from Publisher (SQL Server 2014) Distributor (SQL Server 2014) Subscriber (SQL Server 2008 R2) and initialized it using a snapshot.</p>
  
  <p>Checking in the replication monitor I find that the Snapshot agent has completed successfully and Log Reader agent is running.</p>
  
  <p>Now in 'Distributor to Subscriber History' tab just beside the 'Undistributed Commands' Tab </p>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>The process could not bulk copy into table '"dbo"."BEAMDATA"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)<br>
    Get help: <a href="http://help/MSSQL_REPL20037" rel="nofollow">http://help/MSSQL_REPL20037</a><br>
    End of file reached, terminator missing or field data incomplete<br>
    To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below.  Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)<br>
    Get help: <a href="http://help/20253" rel="nofollow">http://help/20253</a><br>
    bcp "LOWIS_BUCT"."dbo"."BEAMDATA" in "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\ReplData\unc\LOWISBUCT_CSSQLDB_BUCT_CSSQLDB_BUCT_ALL_TABLES\20160826064516\BEAMDATA_34#1.bcp" -e "errorfile" -t"\n\n" -r"\n&lt;,@g>\n" -m10000 -SLOWISTSTSQL -T -w (Source: MSSQLServer, Error number: 20253)<br>
    Get help: <a href="http://help/20253" rel="nofollow">http://help/20253</a> </p>
  </blockquote>
  
  <p>I thought this could be some kind of data overflow and hence checked the schema of the table at both Publisher and Distributor and they match exactly.</p>
  
  <p>I cleaned the whole replication setup completely and re did it but still stuck at the very same place for the same table.</p>
  
  <p>Has anyone encountered this before? Ask me if you need more information from my end which I can furnish. </p>