Failure to BCP load under Transactional Replication. Help! -
01-22-2004
, 03:04 PM
Hello,
We are trying to Execute a DTS Package to load a BCP
file. This file is normally loaded before the SQL Server
Replication and Publication is created. When the data is
Published, a msrepl_tran_version column gets added to
every table.
Now, when we are trying to load the data, it is failing
with a "Bulk insert data conversion error (truncation) for
row 1, column 102, etc...".
I'm thinking that they are all failing now that there is
that added msrepl_tran_version column in the target
table..
UGGH!! Does somebody know a "work-around" for figuring
out how to Bulk Load a BCP file while under SQL Server
Transactional Replication??? That is my issue. Thank you
so much for any help you might be able to provide. |