March 1, 2010 at 10:31 pm
hi there!
my english is bad!! sorry!
i wannt copy data from SQL Server to SQL Azure, SQL Azure have a litter data now, I hope copy data like this!
SQL Server : 1 2 3 4 5 6 7 8 9
SQL Azure : 2 3 11
when copy done,
at SQL Azure: 1 2 3 4 5 6 7 8 9 11
================================================
now follow is my setting:
CopySchema: false
CopyData: true
ExistingData: Append
but I got a Error:
Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__ClassInfo__7C8480AE'. Cannot insert duplicate key in object 'dbo.ClassInfo'.".
helpFile=dtsmsg100.rll helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}".
Task failed: Transfer SQL Server Objects Task
=========================================================
so I need your help! thanks!
March 2, 2010 at 1:03 am
Violation of PRIMARY KEY constraint 'PK__ClassInfo__7C8480AE'. Cannot insert duplicate key in object 'dbo.ClassInfo'.".
constraint is stopping the insert as a result of trying to create duplicate keys.
specify your process to copy all except the rowID column which will generate itself.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2010 at 9:34 am
What you need to do is add a lookup step between the source and the destination.
In SSIS 2005 you have to configure the error path to do this.. You connect the error path to the destination. What you are doing is saying if you DON'T find a match insert it. If you do, do nothing with it.
If this isn't clear, respond back and I can probably make it clearer..
CEWII
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply