25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215

25/08/2011 13:39:03 ----- System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_temp_sett'. Cannot insert duplicate key in object 'dbo.temp_sett'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
   at DataSync.BulkUpload.Upload(DataTable dt, String DestinationTableName, Int32 columnIndexCount) in C:\Projects\AuctionManager\DataSync\Code\BulkUpload.vb:line 19
   at DataSync.AMDataSync.UpdateIMSNet() in C:\Projects\AuctionManager\DataSync\Service\AMDataSync.asmx.vb:line 215