|
Home > Archive > BizTalk Server > August 2004 > Flat Files to SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have a requirement that I need to take an inbound XML Document, Convert it to a Positional Flat File, then submit that whole Positional Flat File into a single cell in a table on SQL server.
My thinking was:
1. Convert the XML into a Flat File.
2. Convert the Flat File into a String
3. Map to an Updategram for insertion into SQL
Is this the best way to accomplish this?
My problem with this is, I want to convert from XML to Flat File inside my Orchestration then map to the Updategram all in one Orchestration. Is that possible?
I think I need to call the pipeline flat file assembler to make the flat file. Can this be called inside the Orchestration?
Thanks.
| |
| Bill Ticehurst [MSFT] 2004-08-30, 2:49 am |
| Hi,
I've a few questions on this scenario before I attempt any suggestions:
- What version of BizTalk Server are you using?
- How big will the flat file be and what data type is the column in SQL
Server going to be? (i.e. will it be under 8000 ASCII chars and put into a
char column? Or over 8000 bytes and written to a text column?)
- Is it a requirement to do all the work in one orchestration? Or just a
preference?
Regards,
- Bill Ticehurst [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| From: "=?Utf-8?B?U3RldmU=?=" <swthomas_98@hotmail.com>
| Subject: Flat Files to SQL
| Date: Wed, 28 Apr 2004 14:36:05 -0700
|
| I have a requirement that I need to take an inbound XML Document, Convert
it to a Positional Flat File, then submit that whole Positional Flat File
into a single cell in a table on SQL server.
My thinking was:
1. Convert the XML into a Flat File.
2. Convert the Flat File into a String
3. Map to an Updategram for insertion into SQL
Is this the best way to accomplish this?
My problem with this is, I want to convert from XML to Flat File inside my
Orchestration then map to the Updategram all in one Orchestration. Is that
possible?
I think I need to call the pipeline flat file assembler to make the flat
file. Can this be called inside the Orchestration?
Thanks.
|
|
|
|
|
|