dbTalk Databases Forums  

Failure to BCP load under Transactional Replication. Help!

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Failure to BCP load under Transactional Replication. Help! in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daren Becker
 
Posts: n/a

Default 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.