Re: violation of primary key constraint
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/16/04
- Next message: Darren Green: "Re: Specified filename does not exist"
- Previous message: Darren Green: "Re: violation of primary key constraint"
- In reply to: Andrew Gale: "violation of primary key constraint"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 17:26:31 -0000
How strange
I would make sure that the VB version being called is going to the place you
think it is.
If there is no PK on the table SIG then you should not have the problem you
are getting unless you are pointing to another version of the table
somewhere else.
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Andrew Gale" <AGale10495@aol.com> wrote in message news:O%23o5Xi3CEHA.4080@TK2MSFTNGP09.phx.gbl... > when i try to run a sql server package from visual basic, i get the > following message: > > Execution Started: 3/16/2004 11:31:54 AM > Error at Destination for Row number 26276. Errors encountered so far in this > task: 1. > Error Source: Microsoft OLE DB Provider for SQL Server > Error Description:The statement has been terminated. > Error Help File: > Error Help Context ID:0 > Error Source: Microsoft OLE DB Provider for SQL Server > Error Description:Violation of PRIMARY KEY constraint 'PK_SIG'. Cannot > insert duplicate key in object 'SIG'. > Error Help File: > Error Help Context ID:0 > Execution Completed: 3/16/2004 11:32:00 AM > > > the data being imported is unique and i even removed the primary keys and > all data from the table, and i still get this error. > everything used to work fine - but we recently upgraded to 2003 Server at > work, and sql server 2000 no longer has the latest service pack (no service > pack in fact). i ran several DBCC commands to no avail - the tables seem to > be intact - i even dropped them and recreated them. > > note: i can run the packages successfully by hand from enterprise manager, > just not from visual basic. > > could this be a bug that a service pack will fix? any help would be > appreciated.... > > i'm using winXP (server/client), sqlserver2000 (rtm), visual basic 6.0 > > -- > andrew gale > agale10495@aol.com > >
- Next message: Darren Green: "Re: Specified filename does not exist"
- Previous message: Darren Green: "Re: violation of primary key constraint"
- In reply to: Andrew Gale: "violation of primary key constraint"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
