SQL Server Import Export Wizzard

Hi fellow experts,

Have two databases within SQL Server on the same server. I am trying to Import/Export Data from one database to another using the Import/Export Wizard. The reason i am doing it this way is that i would only like to transfer the contents of a select few tables within the database.

I have done this before many times on SQL Server 2000 and once before on 2005 which worked without a hitch. Both databases are version 2005 this time aswell. Here is the error i am getting -






- Copying to [holidays_Hotels].[dbo].[Hot_Item] (Error)
Messages
Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
 (SQL Server Import and Export Wizard)
 
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: "The statement has been terminated.".
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Violation of PRIMARY KEY constraint 'PK_Hot_Item'. Cannot insert duplicate key in object 'dbo.Hot_Item'.".
 (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 - Hot_Item" (64) 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)
 



I have logged in with administrator rights, and tried with identity insert aswell as without. Any ideas?

Thanks in advance,
FRACTURE
Start Free Trial