|
Home > Archive > BizTalk Server Orchestration > May 2006 > Flat file multi rows to sql table
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]
| Author |
Flat file multi rows to sql table
|
|
| dgator 2006-05-22, 1:14 pm |
| I have a senerio where I must pickup a flat file, truncate data from a temp
table, and load the data from the flat file into the sql server table. After
I finish putting the data into a temp table, I may decide to do other
processing on it.
I currently have the flat file going through a pipeline and creating one
single xml file with each row of data I want to insert. I will attach schema
at the end.
Since I need to first delete all rows from the temp table, should I use an
orchestration to first truncate the table, then loop through the file and
insert the rows? I'm new to Orchestrations, so a good step by step example
would be very helpful.
Thanks
<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
xmlns="http://SPG_L3_ChargeCode_Load.L3_outgoing"
targetNamespace="http://SPG_L3_ChargeCode_Load.L3_outgoing"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:element name="AllChargeCodes">
- <xs:complexType>
- <xs:sequence>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="ChargeCodeRecord">
- <xs:complexType>
- <xs:sequence>
<xs:element name="charge_code" type="xs:string" />
<xs:element name="gid" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
| |
| amit chaudhary 2006-05-23, 1:15 pm |
| Hi,
you can use delete sql statement by help of sql adapter to truncate
working table (temp table). i did not use delete sql statement but i am
sure you can.what you can do, delete all the
rows in working table before use it.
now a days i am very busy otherwise i can also tell you the steps.
by!!!!!!
| |
| amit chaudhary 2006-05-23, 1:15 pm |
| u can also use SP to delete the working table.
|
|
|
|
|