views:

50

answers:

0

I am replicating using transactional replication from SQL2005 to SQL2000 however the deployment of the snapshot is failing on the bulk insert of the data into the subscriber tables (works fine to a 2005 subscriber), providing the following error details:

Error 'The process could not bulk copy into table '"dbo"."tableName"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)' ....

The suggestion in the error details is to run the bcp from the command line to get the error:

bcp "databaseName"."dbo"."tableName" in "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\repldata\unc\Testing1234\20091118173514\tableName_2.bcp" -e "errorfile" -t"\n\n" -r"\n<,@g>\n" -m10000 -SECM-DBOLD -T -w

This outputs:

     0 rows copied.

     Network packet size (bytes): 4096
     Clock Time (ms.): total        1

There are no errors outputted.

Any suggestions ?

Dave.