07-06-05 10:51 PM
Hi Wave ---
Not a guru, but see if this makes sense to you: I don't think you need a
custom adapter.
a) Use a flat file schema to convert from delimited to "something else",
i.e. some flavor of xml
b) Use a looping shape in orchestration to iterate through records
c) Use an external component to check each record against the whole, either
by sending your component both the record and the whole every time (very
inefficient) or initialize a little temporary storage in a database
somewhere, then clean up at end of orchestrration (much more efficient if
you can guarantee only one message at a time, as you seem to indicate ...
i.e. once nightly)
d) Use a simple decision shape to examine results of your dupe search
e) Use SMTP adapter to fire off a little mail as required based on decision
rule
f) Repeat
As for timing, if you have to go out and FTP at a certain time, the easiest
way I've ever found to do this is use a very simple little timer app outside
BizTalk to drop a "starter" file in a directory, monitored by a file
adapter, that initiates the orchestration. The message/file doesn't
actually have to be anything useful, as it's just used to activate first
receive shape of orchestration. Alternative might be use SQLAgent to drop a
record at a specific time? Something like that should work fine, as BTS has
no event timer that I know of ...
Might be a nice addition, don't you think product team?
r/Brad
"whidbeywave" <indianiowan@yahoo.com> wrote in message
news:1120623781.044074.27200@g49g2000cwa.googlegroups.com...
> Hello Gurus,
> I like to know how to do the following process using biztalk 2004. On
> every Wednesday 12:25am, a delimited flat file needs to be ftp from
> external site. This file contains list of users. The process needs to
> check for duplicate records by firstname (assume the record have
> first,last name and city). if any duplicate records are found, they
> need to be mailed to somebody@otheroffice.com. Other records needs to
> be send to a .net service GAC component, which does pass it into other
> system.
> I need to implement this GAC component too.
>
> My first assumption was just to configure and everything would be fine,
> but later on it looks like a task of rolling sleeves on with creating
> custom pipeline components or customize adapter. What is the
> recommendation? Thank you for helping me out. Any code or link would be
> cool.
>
> Thanks
> Wave.
>
[ Post a follow-up to this message ]
| 
