hi thx for your help but i allready did some changes.
now i have this.
database A has table: Artikelen
–> ID, Order_ID, Productnaam, Aantal, Status
Database B has table: ArtikelenMagazijn
–> ID, Order_ID, Productnaam, Aantal
now what i did is adding a status, so only the statusses with 1 would be updatet.
I made a stored procedure in the SQL Server 2005:
[quote:6ecbaaab3e]set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[SP_ArtikelenSelect]
@Status varchar(1)
AS
select ID, Order_ID, Productnaam, Aantal, Status
from Artikelen
where Status = @Status
for xml auto, XMLDATA
[/quote:6ecbaaab3e]
then i made a generated item again for the receive port with the stored procedure, where i put the value of status to \”1\”.
next i add a generated item again for the send port with all the database fields of database B. (artikelenMagazijn)
next i have a transformmap where i connect ID from receiveschema to the ID in the <BEFORE> from the SEND schema.
and i connect the Aantal from RECEIVE schema to the Aantal in the <AFTER> from the SEND Schema.
Now this works again not like it has to be…
normally the status from database A should change to 0 so he wouldn’t be approached like every second.
and i have this error in my eventlog:
[quote:6ecbaaab3e]A message sent to adapter \”SQL\” on send port \”SendSQLOrderSysteem\” with URI \”SQL://AWS00401\\STAGE/Ordersysteem/\” is suspended.
Error details: HRESULT=\”0x80004005\” Description=\”All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id\”
<Root xmlns:ns00=\”urn:schemas-microsoft-com:xml-updategram\”><?MSSQLError HResult=\”0x80004005\” Source=\”Microsoft XML Extensions to SQL Server\” Description=\”All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id\”?></Root> [/quote:6ecbaaab3e]
any luck to solve this?
thx for everything
Thomas