SQL Send Port and Message Context

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

SQL Send Port and Message Context

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> SQL Send Port and Message Context

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Send Port and Message Context - 29 November 2007

Ritley

Posts: 4
Score: 0
Joined: 29 November 2007
Status: offline

I am currently working on a project that requires me to pick up a file from a specific folder and post it to a partner's website via HTTPS. Once our partner processes the file they create a log file that we again pick up from them via a separate windows component (since it's done via HTTPS).

The problem I am having is that I want to be able to run a report which tells me what files have been sent but that we have not logged.

In order to do this I want to write the name of the file and also a BatchID (since we work with multiple trustees and administrators and file names aren't necessarily unique across all these trustees and administrators) to a table

I have already created the stored procedure that will insert the values I need into a table and have generated an adapter off of that. But I am running into problems with the SQL send port and how to go about giving it the information I need.

I am not all that familiar with orchestration but I originally tried constructing a message that held FILE.ReceivedFileName and also BatchID (which is a promoted property in a referenced property schema) but I run into "use of unconstructed message" errors. Is it even possible to accomplish what I need through the message context? Should I be using map shapes instead? I am admittedly not an expert on orchestration whatsoever but it seems to be the only way I can accomplish this.

Any help would be greatly appreciated. I am using BizTalk server 2004