Data Conversion Failed

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  August 18, 2009 at 3:05 pm

  #385209

  I was running my initial snapshot and it keeps giving me this error; I am running SQL 2005 to SQL 2005 same DB I even restored my last full backup.

  Message: Data conversion failed

  Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)

  at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)

  at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)

  at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()

  at Microsoft.SqlServer.Replication.MainWorkerThread.AgentThreadProc()

  at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)

  MCSE SQL Server 2012\2014\2016

• teriyaki-89

  SSC Enthusiast

  Points: 165

  More actions

  June 16, 2010 at 9:26 pm

  #1181344

  i am having the same problem. If you have solved it could you tell the possuble decision

• David Paskiet

  SSCrazy

  Points: 2949

  More actions

  March 25, 2011 at 9:46 am

  #1303680

  HAs anyone answered here?

  Kindest Regards,
  David

  ** Obstacles are those frightening things that appear when we take our eyes off the goal. **