Re: Polling SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

You can use the SQL adapter to accomplish this. It will poll for you, and
then you can have a send port subscribed (with a map and flat file assembler
in a pipeline) or an orchestration subscribed.

Whether this is an appropriate use of BizTalk depends on what else you are
trying to accomplish (like, what are you going to do with the flat file when
you are done?)

Scott Colestock
www.traceofthought.net


"Adam Beal" <AdamBeal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:89CD3A24-E5E8-481C-9B7F-66EE09427CAA@xxxxxxxxxxxxxxxx
How would I go about polling SQL server on an interval to construct a flat
file for sending if certain results are found. Also, is this even an
appropriate use for BizTalk since there is no incoming or initiating
message?
--
Thanks,

Adam


.

Relevant Pages

  • Re: Flat file XSDs
    ... This may be achievable in Biztalk using the FF Disassembler and a map. ... line into the header. ... wholely unsuited to import by BizTalk Flat File Schema Wizard. ...
    (microsoft.public.biztalk.general)
  • RE: BizTalk map to transform flat files to xml file
    ... it is possible to map flat file to XML. ... BizTalk you simply have to define a Schema for it using the Flat File ...
    (microsoft.public.biztalk.general)
  • Re: Flat File Carrige Returns
    ... Can you zip up the schemas, map and test instance. ... > I am mapping one flat file to another using BizTalk 2002. ...
    (microsoft.public.biztalk.general)
  • RE: Creating custom pipeline components [BT2004]
    ... Did you put the CustomPipe.dll into Program Files\Microsoft Biztalk Server ... I'm currently working on a project that requires a flat file to be read, ... The obvious way to do this seems to be to use a custom ... decoder component before the flat file is dissasembled in the pipeline. ...
    (microsoft.public.biztalk.general)
  • Re: XML file size when using mapping and orchestration
    ... We loaded the file as single records into an Oracle table as XML (covered ... the whole flat file into Xml using messaging) all with the same batch id. ... Then we pulled the records out of the table inside an Orchestration, ... Biztalk as a full message. ...
    (microsoft.public.biztalk.general)