export data from one table to the other

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

export data from one table to the other

Author

Topic

ikeguluo
Starting Member

15 Posts

Posted - 2008-10-27 : 11:40:56

Hi

Im trying to export data from one table to the other and im getting the error
Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint '
'dbo.tblStaffDirectory_Area'.".
(SQL Server Import and Export Wizard)

Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
(SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - tblStaffDirectory_Area" (28) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
(SQL Server Import and Export Wizard)

Can anybody help me with this

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2008-10-27 : 20:46:53

Violation of primary key occures when you have more than one of the same values for the target tables primary key column.

You can do anything at www.zombo.com