Truncate a table from within an Orcastration

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

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

Truncate a table from within an Orcastration

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 >> Truncate a table from within an Orcastration

Page: [1]

Message

<< Older Topic Newer Topic >>

Truncate a table from within an Orcastration - 30 August 2006

simonvinyl

Posts: 3
Score: 0
Joined: 23 August 2006
Status: offline

I am new to Biztalk and so this is proably a low level question.

I have an orcastration that inserts new data into a table, however i need to truncate the table before inserting. I have an SQL Server 2000 stored proc that does this but how do i call it from within BizTalk as the stored proc doesn't take any parameters (so i cannot apply ,xmldata) and is nothing like the receiving insert message?

Could i pass SQL directly from an Orcastration?

Thanks in advance