Hello I'm reading a delimeted input file and putting that info on SQL Server. Depending on "shop_number" field (that is not PK) from the file, I have to update an existing row or insert a new one into the DB. On my tMSSqlOutput ("Pedido") I selected "update or insert" option on data, and removed the PK field from the schema, I also marked the "shop_number" as key. But when I execute the project, it gets stucked in the red circled part.
I used "sp_who" in the database, and it seems that talend is locking the table and it cant goes on.
whay should I do to get my data into the table? (if im not being clear enough, let me know, so I try to explain it another way)
You wouldn't be able to insert without a proper primary key. You can use pedido as a lookup to match the num_pedido to and use the primary key from that for modify or you could use a tMSSQLRow for the update with an update where condition.
I think I will use pedido as a lookup, that might work, Thank you. I cant do that right now, but ASAP I will try this and post here if it worked or not.
