Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Execute Stored Procedure after updategram send port?
- This topic has 1 reply, 1 voice, and was last updated 9 years, 5 months ago by
community-content.
-
AuthorPosts
-
-
February 6, 2010 at 5:01 PM #24213
I am able to read the csv file and map it to an updategram and succesfully inserting the received filename and the bulk data into the database, but now the issue i have is , I have to also execute a stored procedure immediately after the updategram send port.
the stored procedure does not accept any parameter not returns any values. (what it does is as follows:
create PROCEDURE [dbo].[Usp_Insert_CustomerInfo]
retreive filename from sales_dump table and get the dealerid based on the dealercode from dbo.dealer table
DECLARE @filename varchar(255)
DECLARE @DealerCode varchar(50)
DECLARE @DealerID int
Select @filename = Reverse(left(Reverse(ReceivedFileName),Charindex(‘\’,Reverse(ReceivedFileName))-1)) From dbo.Sales_DataDump
SET @DealerCode = (select * from dbo.fnParseStringTSQL(@filename,‘_’))
SET @DealerID = (select dealerid from dbo.Dealer where dealercode = @Dealercode)
–FROM SALES_DATADUMP INTO
–1) INSERT DATA INTO Customer_Contact_Info_DetailINSERT dbo.Customer_Contact_Info_Detail(CustomerID,DealerID,Address,Address2 ,City,State,ZipCode,HomePhone,OfficePhone,CellPhone,Email) SELECT CustomerID,@DealerID,Address,Address2 ,City,State,ZipCode,HomePhone,OfficePhone,CellPhone,Email FROM dbo.Sales_DataDump
—————————————————————————————-
THIS IS THE STORED PROCEDURE THAT I NEED TO EXECUTE IN THE SEND PORT OF ORCHESTRATION AFTER THE SEND PORT OF UPDATEGRAM IS EXECUTED (AND I AM NOT ABLE TO EXECUTE ANY CODE AFTER THE SEND PORT FOR UPDATEGRAM IS IMPLEMENTED.SO BASICALLY – I NEED
1 RECEIVE PORT (for flat file),
1 send port for (updategram to insert data into sales_dump table)
1 send port to (execute Stored procedure call wihtout any parameters or no return values) just trigger execute.is this possible (i have been breaking my head on this issue since 1 week. (its very urgent) any help is gr8tly appreciated.
-
March 22, 2010 at 1:44 PM #24437
You can call another Send Shape which executes the Stored procedure taking the xml as a parameter but dont do anything with that parameter.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.