Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

cannot bulk copy into a table 'tablename" that is enabled for immediate updating Expand / Collapse
Author
Message
Posted Monday, July 5, 2010 2:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 30, 2010 3:13 AM
Points: 10, Visits: 28
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
Post #947410
Posted Tuesday, July 6, 2010 1:56 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:47 AM
Points: 6,259, Visits: 2,029
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
Post #948159
Posted Wednesday, July 7, 2010 3:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 30, 2010 3:13 AM
Points: 10, Visits: 28
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}'
Post #948393
Posted Wednesday, July 7, 2010 7:21 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:47 AM
Points: 6,259, Visits: 2,029
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
Post #948520
Posted Wednesday, July 7, 2010 7:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 30, 2010 3:13 AM
Points: 10, Visits: 28
Ok, Thanks for your response, will try enabling the FIRE_TRIGGERS flag and see how it goes.
Post #948533
Posted Friday, July 9, 2010 8:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 30, 2010 3:13 AM
Points: 10, Visits: 28
Unfortunately, i added the fire triggers and it didn't make any difference.
Post #949970
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse