I have used an inbound and outbound schema and the basic mapping is working fine.
When I add a dblookup along with value extractor functoid it is not working.
Both database and biztalk runs on the same computer. The connection string is a valid string and I used SQLOLEDB provider with Persist Security Info=false and provided all other credentials.
I had validated inbound, outbound and maps no errors were thrown.
Any help would be much appreciated.
can you let me know the error in more detail
I don't know what's the problem! schemas and maps are tested and validated with no issues
There might be some configuration issue. The problem is ValueExtractor functoid wont return you any Error if any. It will return blank.
So what you can do is use a Error Return Functoid and see if any Error is returned. Most probably it is access issue with databases.
msdn.microsoft.com/.../aa559365(v=bts.20).aspx
Regards,NISHIL MCT,MCTS | Freelance BizTalk Consultant.biztalkconnect.blogspot.com