BizTalk - Updating a database table entry based on the filename of the file gene
Asked By Abhishek Iyer
19-Aug-10 05:15 AM
Hi friends,
I have a scenario in which a file is generated at a folder location and based on the file-name, I have to update an entry in a database table. Is this possible? If yes, how is it to be achieved?
Awaiting a reply at the earliest.
Sania replied to Abhishek Iyer
As far as I understand the question you need to create different receive location configuring the file mask like filename*.* i am not sure that all the files are having same schema or not , If yes ,then inside orchestration you can put the logic to update the database or call the stored procedure etc.
If the files have different schema still you can grab the files from different receive locations and subscribe it to its message type inside the orchestration
Thanks
Sania
Biztalk Stored Procedure problems with NULL value Hi All, In my Biztalk(2004) Orchestration, I use a stored procedure to update some tables in a database hosted by SQL Server 2003. The input of
Calling Stored procedure without parameters in BizTalk using SQL Adapter Hi I know how to use a SQL adapter calling a stored procedure with parameters from Orchestration, but how to call stored procedure without parameters when I generate metadata for the stored procedure I m just gettin the request root node so my question is do I
Error message from SQL adapter Windows Server I have a two-way send-receive SQL BizTalk port (BizTalk 2006). This port executes a stored procedure (SQL Server 2005). This stored procedure returns the content of a column of type 'text'. Sending a request to the sql port triggers the following error from BizTalk: A message sent to adapter "SQL" on send port "RequestToSQLPort" with URI "SQL: / / localhost / MyDB suspended. Error details: HRESULT = "0x 7a" Description = "No error description provided" After having edited the stored procedure so that the text column is converted to a local varchar(8000) variable and
xml DATA FROM ORCHESTRATION to stored procedure xml parameter Windows Server i want to pass xml DATA FROM ORCHESTRATION to stored procedure xml parameter. I want to copy xml tree from source message to Stored procedure xml parameter. My problem is that mass copy cannot be assigned to a attribute field While generated scheama wizard makes parameters of stored procedure as an attribute. So how can i copy the xml into a generated schema xml
Calling parameterized SQL Stored Procedure through Orchestration Windows Server I want to call stored procedure with simple SELECT query [in loop] from orchestration which takes an input parameter [say customerCode am not aware of the way wherein I can pass the variable parameter to my stored procedure. I call the stored procedure in loop [say 5 times] and each time I call the SP I need to