Hey !
I know that this is the eConnect forum but I thought you'd be interested in this particular challenge.
My client had a need for an inventory importing tool (using SerialNums). I used a combination of SSIS, .Net (wrapper) and eConnect. It works great. Well, now they want me to extend the tool to include assembly transactions. Well, after I told them "sure", I found out that eConnect doesn't do Assembly Transactions! So, I'm trying to build a SQL script to automate it myself.
After using SQL Trace to see what happens during an assembly transaction insert, I've extracted over 700 lines of t-SQL. (Dexterity does some pretty weird stuff...) Have you had any experience with automating assembly transactions? I'm hoping to boil the trx down to a handful of table inserts and/or updates.
Let me know. Thanks!
Joe Cogan
joecogan@adelphia.net