Forum Replies Created
-
AuthorPosts
-
August 19, 2009 at 6:31 AM in reply to: Consume adapter service Insert-operation and identity value #23065
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)
ENDUse a composite request as described by Richard in his blog to group multiple stored proc calls.
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.
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
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
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?
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.
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.
Thanks.
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.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
August 18, 2009 at 10:43 AM in reply to: Receive location get disabled Automatic "exhausted the network retry attempts." #23051August 18, 2009 at 6:02 AM in reply to: Help needed to loop through child records in the message & pass it to web service. #23049Hi 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 🙂
August 17, 2009 at 8:01 PM in reply to: I’m having trouble deploying from VS2008 – I get "No BizTalk Configuration database(s) found on server". #23048That might be a permission issue
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…?
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.
-
AuthorPosts