I have several DTS packages that I am recreating using SSIS. The source file is a flat file on a remote server. The destination is into an existing database table. This table has data in it already and I will be appending the new data to the existing data. However, the following error occurs:
"The statement has been terminated.". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'C1249703'. Cannot insert duplicate key in object 'CA571L'.".
Can't figure this one out. Please advise, need to resolve this as soon as possible. Thank you very much in advance.