ETL and Data Integration tools - Modern ETL software for everyone

Hello I am trying to load data into SQL Server 2008 and I am getting following errors in the execution log

Error 10/02/2011 3:54:36 PM 1, [Table=[db].[dbo].[Contract]] Update failed: 42000
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot update identity column 'ID'. 42000 [Microsoft][ODBC SQL Server
Driver][SQL Server]Statement(s) could not be prepared.

Any suggestions?

Dave

If you are using Ole DB or ODBC connection put
SET IDENTITY_INSERT table_name ON
Into sql before

If you are using MS Sql Server Connection

Open target connection properties and tick "keep identity"

Peter