You must not be specifying the proper Writeback key(s). When you define the C/E MetaConnection you specify the Grouping Keys, which seems fairly logical - "the shared key which groups multiple values." However, the "Additional Write Keys" is considerably less intuitive. This field must contain the field(s) or column(s) that uniquely identify each multi-value set of fields on the Notes document. Make sense? Still kinda confusing, huh!?!? Here's an example: Let's say you have Notes documents containing book orders with three multi-value fields that you want to expand so that each Nth value gets mapped into a row in SQL Server. For each order you have an Order Number, which is used as the Grouping Key. For each book on the order you have a unique key in the ISBN and the multi-value data contains ISBN, quantity and selling price (since discounts might be applied on a per-order basis.) In this example the ISBN is the Writeback key. LEI will then use the Order Number to find the Notes Document and the Order Number and ISBN together to find the right (Nth) value in SQLServer. Note: You might try using DECS which offers the exact same functionality as the LEI RTNotes Activity (shares the same code base). This would eliminate needing LEI running on your production application.
Dig Deeper on Lotus Notes Domino Administration Tools
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.