cannot bulk copy into a table 'tablename" that is enabled for immediate updating

Question

cannot bulk copy into a table 'tablename" that is enabled for immediate updating

iwegbue3

Old Hand

Points: 394
More actions
July 5, 2010 at 2:49 am

#224539

Hello Experts,
I have a Transactional replication setup with updateable subscription. I tried bulk copying data from the subscriber down to the Publisher and it throws up the error message, "Cannot bulk copy into a table 'tablename" that is enabled for immediate updating.
Please expert help is needed.
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

iwegbue3 (7/5/2010)
Hello Experts,
I have a Transactional replication setup with updateable subscription. I tried bulk copying data from the subscriber down to the Publisher and it throws up the error message, "Cannot bulk copy into a table 'tablename" that is enabled for immediate updating.
Please expert help is needed.
Thanks

Can you describe the steps you followed?

What exactly did you do when you said: "I tried bulk copying data from the subscriber down to the Publisher" ?

* Noel

iwegbue3 Old Hand Points: 394 More actions · Answer 2

Hello Experts,

I have a Transactional replication setup with updateable subscription. I tried bulk copying data from the subscriber down to the Publisher and it throws up the error message, "Cannot bulk copy into a table 'tablename" that is enabled for immediate updating.

Please expert help is needed.

Thanks

Sorry my bad, i tried bulk inserting data into a table at the subscriber end, which i believe should be replicated to the Publisher, but unfortunately, got the error message "Cannot bulk copy into a table 'tablename" that is enabled for immediate updating. Below is the statement issued

BULK INSERT [Table name]

FROM '{0}'

WITH (KEEPIDENTITY,

FIELDTERMINATOR =',',

ROWTERMINATOR = '',

FORMATFILE = '{1}'

noeld SSC Guru Points: 96590 More actions · Answer 3

iwegbue3 (7/7/2010)
Hello Experts,
I have a Transactional replication setup with updateable subscription. I tried bulk copying data from the subscriber down to the Publisher and it throws up the error message, "Cannot bulk copy into a table 'tablename" that is enabled for immediate updating.
Please expert help is needed.
Thanks
Sorry my bad, i tried bulk inserting data into a table at the subscriber end, which i believe should be replicated to the Publisher, but unfortunately, got the error message "Cannot bulk copy into a table 'tablename" that is enabled for immediate updating. Below is the statement issued
BULK INSERT [Table name]
FROM '{0}'
WITH (KEEPIDENTITY,
FIELDTERMINATOR =',',
ROWTERMINATOR = '',
FORMATFILE = '{1}'

The "immediate" updating subscription synchronizes with the publisher using "triggers" and an special linked server that participates in a two-phase committed transaction using MSDTC. Bulk insert by default does NOT fire triggers so this action is probably invalidated because of that.

I have not tried it but probably specifying the FIRE_TRIGGERS flag could help you.

* Noel

iwegbue3 Old Hand Points: 394 More actions · Answer 4

Ok, Thanks for your response, will try enabling the FIRE_TRIGGERS flag and see how it goes.

iwegbue3 Old Hand Points: 394 More actions · Answer 5

Unfortunately, i added the fire triggers and it didn't make any difference.

raviteja_dasari Old Hand Points: 346 More actions · Answer 6

Has this issue been resolved? I am facing a similar issue. I have a sql server 2008 R2 database and we have Transactional replication with immediate-updating subscriptions.

I need to bulk copy data into a table at a subscriber and I am getting the same error.

Can someone please post a solution to this issue?