Hi,

For one of my apps, users can e-mail me an encrypted file which I in turn decrypt and do Bulk Inserts into tables in a SQL Server 2000 database (for troubleshooting purposes).

With the following code, I am trying to do a bulk insert into a table named 'ReportControl'. The file that I'm doing the bulk insert with includes the identity column (and it's values). When I do the bulk insert with this code, the data gets inserted, but the identity column incriments - but I don't want that to happen - I want the value in the bulk insert text file to be inserted into the table.

Here is a snippet of the code (for table ReportControl):

Print 'Disabling all Constraints'
GO
sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO

--/////////////////////////////////////////////

PRINT 'Deleting from table: [dbo].[ReportControl]'
DELETE FROM [dbo].[ReportControl]
GO

SET IDENTITY_INSERT [ReportControl] ON
GO

PRINT 'Bulk Insert into table: [dbo].[ReportControl]'
BULK INSERT ATMPOS.dbo.[ReportControl] 
From 'F:\Import\ReportControl.lds' 
WITH (FIELDTERMINATOR = '|',KEEPNULLS)

GO

SET IDENTITY_INSERT [ReportControl] OFF
GO

Print ''

--///////////////////////////////////////////////

Print 'Enabling all Constraints'
GO
sp_msforeachtable "ALTER TABLE ? CHECK CONSTRAINT ALL"
GO

How can I do a bulk insert into a table with an identity column and have the data in the bulk insert text file for this field get inserted into the table - rather than having the identity field continuing to incriment?