Forum Replies Created
-
AuthorPosts
-
Eh, novel concept! It would be nice if that could be done!
August 21, 2009 at 8:43 AM in reply to: SQL Adapter Wizard disappears while generating schema #23083hi russel,
i’m trying to create a new SqlAdapter receive port in Biztalk2009 throgh the wizard and after selecting the SELECT STATEMENT and on pressing the next button the wizard just disappears.
I have SqlServer 2008 installed and i have sqlxml sp3 and msxml6.0
any ideas abt the prob?
August 21, 2009 at 4:26 AM in reply to: What the Limitations of BizTalk on Integrating Legacy System Like AS400 #23081Can some one give me idea?…. I am in really struggle over this
well, there is no way you can pick up filename wich will be assigned inside your send port only.
MessageID will always be different from what you can read in your orchestration because when a message after send pipelines comes into send adapter – it already has a new MessageID.
If you really require using the same file name in you E-mail attachment, you can build a file name in your orchestration (you can generate GUID if you want a unique name) and include it into message as yourOutputFileMessage(FILE.ReceivedFileName). Then in FILE send port you use %SourceFileName% macro. Later in the orchestration you just use your in-house built file name to assign it to an attachment.
Jason,
That’s pretty much the process. Shoot me an e-mail if you run into any further problems.
Jeff
jeff dot sanders at dynamicshift dot com
Hi Siva,
I found this information on building custom functoids:
http://techsavygal.wordpress.com/2006/02/28/creating-custom-functoids-in-biztalk-server-2006/
Hopefully this will help you troubleshoot and solve your problem…
Daniel.
You could try the HTTP.ResponseStatusCode message property. Not sure if it makes it into the HTTP.InboundHttpHeaders message property
August 20, 2009 at 1:36 PM in reply to: The request failed with HTTP status 401: Unauthorized #23075Hi,
This is a problem when you are trying to access an unauthorized resource and you verify that by copying and pasting the URL into your web browser’s address bar and hitting the Go button. Resolve this issue and I think you should be able to send the message successfully using the CRM Adapter in BizTalk.
Daniel.
Hi Ron,
I don’t recall using an SFTP adapter from a BizTalk orchestration to exchange information with external partners, but I implemented a standalone .NET application which transferred a data file to an external partner using SFTP protocol, and this program resides in our secure corporate internal network (behind a firewall). So I assume that you could do the same for your BizTalk scenario.
Also, BizTalk 2006 R2 platform does not supply any SFTP adapter with its SDK, so you will need to buy a third-party software module to implement that in your project. One good place to look for that kind of adapter is /n Software Inc., and here is the link to that particular adapter:
http://www.nsoftware.com/products/biztalk/adapters/sftp.aspx
Best of luck with your project!
Daniel.
Hi Nandika,
Have you tried running this standalone application on its own and what are the results? Are you getting the error message in that case too? This is most likely something to do with you .NET code and not specific to BizTalk.
Dan.
Thanks for the reply.
I’ve implemented a receive pipline with a Flat File Disassembler and within the orchestration can access the content that is in the body of the HTTP response.
So now I need to access the return code from the response, how can I do that?
your_Message(FILE.ReceivedFileName)
Ehm.
With “YourMessage(BTS.MessageID)” I get this number: “a47f864c-7ca6-44d4-bcc5-7571ff936dec”.
The file created with %MessageID% is “2353C343-4131-4910-9989-055F5CC201AD”.
Thanks Jeff. I will check with the DBA to ensure that the Analysis Services is intalled on the SQL Server.
Just to confirm the steps for BAM backuk
1. Run “Backup BizTalk Server” Job for BAMPrimaryImport
2. Execute all BAM_DM_<activity name> packages
3. Use Analysis Services to back up BAMAnalysis
4. Use Enterprise Manger to backup BAMStarSchems and BAMArchive.
Thanks,
Jason
Thanks for your quick response. question though. How do I make the request/response port public?
Thanks
Surkum
-
AuthorPosts