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}'