BizTalk - using 2 send ports one for updategram and one for stored procedure without parameters

hi all,

  I have been breaking my head on this issue for last 4 days without any luck, any help is greatly appreciated

I have a flat file which I  am reading and inserting into sql server using Updategram. and then once that data is inserted into the database, I need to execute a stored procedure from biztalk to break the data into respective details tables inside the database.

I have a Receive Port to read flat file

i have a send prot to insert flat file data usign updategram into the database

i need a send port to execute a stored procedure from biztalk once the insert flat file step is performed.

I dont have to return or accept any parameters in the stored procedure(just need to execute it from biztalk once the insert send port triggers)

thanks

 

 

 

 

Ok. Please ensure if this provides the required workaround for your problem.

Though we can make use of triggers in this scenario, a simple orchestration might seem an effective alternative. Or use the below two approaches:

First:

The mappings and orchestrations required to load data into SQL through updategram can very well be done in the same stored procedure that you need to execute later. This way we can make sure that the SP is executed soon after the update process.

Second:

Also you can implement the AFTER UPDATE trigger to achieve this. See link for reference:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/sqlp/rbafyaftersql.htm

thankyou for your prompt response, but my scenario demands me to do everything in biztalk - either using pipeline or map or ochestration.

and I have seen an example where someone is already doing this and I tried to implement the same but somehow the first send port for updategram works , but the second send port which has the execute stored procedure method doesnt fire.

http://www.markscott.net/post/2008/01/25/Executing-a-stored-procedure-via-BizTalk-with-no-parameters.aspx

this link has the exact example i am looking for inspite , its not wrking for me.

any help is greatly appreciated.

thanks