multiple repeatable "could not bulk copy out of table"

[Dwaine]

We're using snapshot repl to move tables/data to divisions. Recently,
the method of populating the tables on the distributer/publisher
changed from TextFile/DTS to DB2/DTS, not very exciting. Now during
shapshot build for ONE division (out of 4) we get the following error:

Bulk copying snapshot data for article 'POF'
select * from [dbo].[syncobj_0x3937443834433942] where 1 = 2
[5/17/2005 7:50:57 AM]AAG0J6DW04.ODS: select * from
[dbo].[syncobj_0x3937443834433942] where 1 = 2

*** [Publication:'CCE'] Total snapshot generation time excluding
publication setup: 666140 (ms) ***

SourceTypeId = 5
SourceName = AAG0J6DW04
ErrorCode = 8114
ErrorText = Error converting data type varchar to float.
The process could not bulk copy out of table
'[dbo].[syncobj_0x3937443834433942]'.

POF is the table here, but it started as a different table. When I
removed that table from the publication it's now erroring on a
subsequent table.

What could be causing such an error on the data of multiple tables
who's definition hasn't changed? Bottom line is the data is ALREADY
LOADED into the tables schema with no errors! This is the snapshot
agent loading the data into a bcp file for packaging, and the target
schema is WRONG??!!

I've removed and re-added tables from the publication and this doesn't
fix it. I'll probably drop and re-create the entire publication and
cross my fingers, but I'd like to know what is happening at this stage
of the snapshot process that requires data definition?

[Hilary Cotter]

Are the schemas identical? Are both the publisher and subscriber SQL Server?
The DB2/DTS is making me wonder.

You should not be getting this error. Could you post your publication script
and the schema for POF here?

Completely dropping the publication and subscriber should fix this.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Dwaine" <dxwr...@parker.com> wrote in message
news:1116349454.5...@g49g2000cwa.googlegroups.com...