| Author |
Using SQL Adapter to write information into two different tables ?
|
|
| Raed Sawalha 2004-10-16, 7:47 am |
| Dear :
I have application that write XML file on a folder then biztalk server pick
it up and write its information into sql server database.
but we update the XML so that each action should insert 2 record into
different tables.
i tired to do it but always got my message into Retry Quest with no
processing server message.Why?
Anybody can provide me with link or online sample for how to allow sql data
adapter to write two records into different tables.
Regards
| |
| Alan Smith 2004-10-18, 7:46 am |
| Hi,
You could create a stored procedure to do this, then create an SQL schema
based on the stored procedure.
/Alan
"Raed Sawalha" wrote:
> Dear :
> I have application that write XML file on a folder then biztalk server pick
> it up and write its information into sql server database.
>
> but we update the XML so that each action should insert 2 record into
> different tables.
> i tired to do it but always got my message into Retry Quest with no
> processing server message.Why?
> Anybody can provide me with link or online sample for how to allow sql data
> adapter to write two records into different tables.
>
> Regards
| |
| Niklas E 2004-11-02, 7:46 am |
| Unfortunately, the wizard can only generate the schema for insert into one
table. Open your generated schema in notepad and copy the table node into a
new node and rename and change the columns in it to your other table.
There are a number of bugs in the SQL Adapter so I suggest that you update
it:
841612 is a SQL-adapter update.
Best regards
Niklas E
"Raed Sawalha" <RaedSawalha@discussions.microsoft.com> wrote in message
news:5915EC66-1AF8-4923-91C9-529F34046222@microsoft.com...
> Dear :
> I have application that write XML file on a folder then biztalk server
pick
> it up and write its information into sql server database.
>
> but we update the XML so that each action should insert 2 record into
> different tables.
> i tired to do it but always got my message into Retry Quest with no
> processing server message.Why?
> Anybody can provide me with link or online sample for how to allow sql
data
> adapter to write two records into different tables.
>
> Regards
|
|
|
|