POP3 attachments

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

POP3 attachments

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 >> POP3 attachments

Page: [1]

Message

<< Older Topic Newer Topic >>

POP3 attachments - 8 February 2008

brupert

Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline

I have an orchestration that uses the pop3 adapter to strip attachments off an email and saves them into a temp folder. I have a receive Excel pipeline on that temp folder that parses the Excel files to XML. It works great when you know the worksheet name.

The Excel Pipeline has the sql statement to get the data off the Excel Worksheet (i.e. select * from [Sheet1$]) In this particular case, there are 9 attachments (spreadsheets). Do you know a way to select * from the worksheets without knowing the worksheet name? Or is there a way to preserve the filename off the attachments? %SourceFileName% does not work.