Exporting to SQL Server (1 Viewer)

ECEK

Registered User.
Local time
Today, 18:10
Joined
Dec 19, 2012
Messages
717
I am trying to automate exporting several RunSavedExport but I've come up against the " IDENTITY_INSERT is already on"

I have tried to call a pass-through query after each import as follows:

Code:
ALTER PROCEDURE [dbo].[IdentityMyTable]
AS
BEGIN
SET IDENTITY_INSERT [dbo].[tblMyTable]  OFF  
END

But the error still exists when I run the next Export.
Could anybody point me in the right direction ?
 

Ranman256

Well-known member
Local time
Today, 14:10
Joined
Apr 9, 2015
Messages
4,339
append query
 

Users who are viewing this thread

Top Bottom