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.  Afte
r
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 schem
a
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>

[ Post a follow-up to this message ]

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!!!!!!

[ Post a follow-up to this message ]

u can also use SP to delete the working table.

[ Post a follow-up to this message ]