Re: First timers question
- From: Dan Rosanova <dnova7@xxxxxxxxx>
- Date: Tue, 16 Jun 2009 07:26:49 -0700 (PDT)
You will need a visual studio project because you'll need to create a
schema that represents the SP call (or SQL Insert). You can do this
without Orchestration by having a Filter on the send port that matches
the BTS.ReceivePortName or BTS.MessageType of the received message
(ideally you'd use both to be really specific).
Also, even if you're XML is already in "the right format" you should
map into a canonical (internal) format when you receive (receive port)
and map out to the external SQL format (send port). Lastly the SQL
Adapter, unless you're using BT 2009, does not have an XML type and
you use the SQL Adapte Wizard from within the IDE to create your
schema for SQL Server. If you need more info check out my blog
entries:
http://www.novaenterprisesystems.com/Blog/post/More-SQL-Adapter-(Ab)Use.aspx
http://www.novaenterprisesystems.com/Blog/post/SQL-Server-Adapter-Port-(Ab)Use.aspx
Kind Regards,
-Dan
.
- Prev by Date: Re: Split message after performing a mapping
- Next by Date: RE: Which Oracle adapter to use?
- Previous by thread: How to ignore extra carriage return/line feed at the end of Flat File
- Next by thread: Very odd behaviour of our receivehost (bts2006 R2)
- Index(es):
Relevant Pages
|
