- This topic has 4 replies, 1 voice, and was last updated 5 years, 3 months ago by
.
-
Posts
-
-
I’ve been putting together a map which outputs to a complex schema created by the SQL Adapter wizard. The problem is, the query I fed to the wizard left out some table columns I now need to access. It’s a lot of work to run the wizard again and redo the map, and I don’t know if it’s safe to modify the query in the schema, (I could do that outside BizTalk using an XML editor), so I thought it would be less work to add some database functoids to the existing map.
Now here comes the crunch. The table I want to get data from, has a two-column primary key, but the database functoid only accepts one column name as an input. How do I work round this? If anyone knows, you have my gratitude forever!
🙄 J
-
Stephen,
I have thought about that since posting. You can create a Custom Functoid using .NET classes, by inheriting from the Microsoft.BizTalk.BaseFunctoids class. There’s a sample in the SDK that comes with BizTalk 2003 -but it’s not a database sample.
Ideally it would be great if you could inherit from the standard database functoid, then add another input for a second datase column, but I can’t see any example code that shows how to construct such an input. So I’m a bit stuck.
I hope they have extended this area in the new 2006 version !
-John
-
Hello.
I don’t know of a way around it.
Could you call a custom .net component inside the map to return your data?
-
-
-
Foul is Fair – Hannah Capin – 9781250239549
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.