community-content

Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 9,648 total)
  • Author
    Posts
  • One possibility is to use a stored procedure:

    mystoredprc @T1Field1, @T1 Field2, @T2Field1, @T2field2
    BEGIN
      INSERT INTO Table1 (FieldName1, FieldName2) VALUES (@T1Field1, @T1 Field2)
      INSERT INTO Table2 (Table1ID, FieldName1, FieldName2) VALUES (@@IDENTITY, @T2Field1, @T2field2)
    END

    Use a composite request as described by Richard in his blog to group multiple stored proc calls.

     

    in reply to: Flat File Schema Validates unexpectedly #23064

    Hi Greg,

    The your suggestion works like charm but when there is a ” (double quote) in one of the Field (string) it will failed. There is a possibility that ” exists as part of data as some fields are free text.

    Any other suggestion?

    Thank you.

    in reply to: Flat File Schema Validates unexpectedly #23063

    I would suggest using the Wrap Character and set it to ” (double quote) for each field.

    You can change your Tags to be just “HEADER”, the record separator to 0x0D 0x0A and the field delimiter to ,

    This definitely fails when you add additional fields to ITEM

    in reply to: Processing external XML data #23061

    You can create a web service that your customers can call to pass you the Xml data.

    Firstly you need to create a schema to define the message formats, both request and response. Then create an orchestration with a request response port (make this public) to receive the Xml message and return a response. In your orchestration perform the required logic to update the mainframe (HIS integration?, flat file creation? …). Then generate the response message.

    Once you have built this solution you can use the Biztalk WCF publishing Wizard that will generate the IIS virtual directory. You can either use the schema definitions and construct your interface or you can use the orchestration port

    in reply to: Biztalk – Error after changing the mapping #23060

    The Root Reference property is set in the schema file. Open the schema file, select the top level <Schema> node and scroll to the bottom of the Property window.

    Did you change the flat file schema?

    Does the Smtp send port run in a host instance that was not restarted after your redeploy?

    in reply to: Master Secret Server #23059

    Check out the BizTalk Operations Guide http://www.microsoft.com/downloads/details.aspx?FamilyID=5251F103-329D-4F8D-95B5-64F99F2F6DFC&displaylang=en#filelist

    It has some information on clustering the Master Secret Server or manual recovery in case of failure.

    If you use a third server, then if this server fails both of your Biztalk Servers will fail.

    in reply to: HTTP Adapter – Handling a Response #23057

    Yes you can handle the returned string.
    You can use a flat file disassembler in the receiving pipeline to turn it into an Xml document. This would be useful if the string contained a number of fields that you want to split out.

    You could possibly use a pass-thru pipeline and declare an orchestration message of type System.String and receive this message. Never tried this.

    You could even write your own pipeline component to convert the string into some message format.

    in reply to: How to get the name of a created file #23056

    Thanks.

     

    in reply to: Flat file as email-attachment #23055

    OMG

    I had 2 Pipelines.

    One with the Mime-Encoder to set the email-address and one with the

    FlatFile-Assembler.

    I put both in 1 Pipeline and thats it…

    The schema of the Message I used to send the email I set to the

    flatfile-schema.

    in reply to: Backing Up BAM #23054

    Jason,

    The SQL Services Analysis Manager is SQL Server Management Studio with Analysis Services installed. Unfortunately, the name is a “hodgepodge” of “SQL Enterprise Manager” and “Analysis Services.” Provided you have installed the client tools and Analysis Services 2008, you should be able to connect to the SQL Server that hosts the databases and perform a backup.

    A BizTalk Admin can perform this task, or it can be performed by a DBA. It’s imperative that as part of your BizTalk backup/restore and solution support strategy, you have worked with your DBA (if one so exists) to determine backup schedules for BizTalk and BAM databases, and taken into account factors such as backup strategy, frequency, failover, physical location of media, SAN/NAS, etc.

    I would recommend you attempt a backup in a test environment first to gain comfort with the process. Then, approach your DBA about how the BAM backup fits into the overall enterprise strategy for backups. There may be additional concerns, such as needs for archiving, HIPAA, Sarbox, or other legal constraints that require the databases to be backed up in a specific way.

     

    Hope that helps,

     

    Jeff Sanders

    jeff dot sanders at dynamicshift dot com

    Author, Pro BAM in BizTalk Server 2009

    Hi KpKing,

    Do you need to debatch and then rebatch the <Employees> incomming message?

    If you don’t then you could make your Receive Pipeline split the messages up and just process each Employee separately; generate ports and message types from the web service, map the Employee msg to web service request, generate the update message from the web service response msg as an example 🙂

    That might be a permission issue

    in reply to: Many to One Mapping #23047

    I tried with E2EDSP1GRP but its an Loopiing segment…so not working….I could not understand point 2 and 3 …can u explain a bit…?

    in reply to: Biztalk messaging and debatching #23046

    Hi,

    Check out the following sample from Biztalkgurus:

    http://www.biztalkgurus.com/media/p/15564.aspx

    That should point you in the right direction…

    Daniel.

     

Viewing 15 posts - 2,401 through 2,415 (of 9,648 total)