I have a CSV file that has multiple transactions in it. I have created a flat file schema for it and works fine. I need to upload the transactions in the CSV file one record at a time into a SQL database. Only the first record is being uploaded. What do I need to do for it upload all the records within the file ? I have tried various schema properties options with no success.
Can you give us more detail here? Is this a solution which uses an orchestration, or is it a messaging only solution? How are you pushing information into the database? through the sql adapter or is it through a service which provides access to the database?
Assuming you’ve already got the main concept working for one record, the changes are: (I suggest you’re using a stored procedure to feed data into a database)
1. In the SQL schema, change Max Occurs property of the SQL record (an element with the SP name) to unbounded.
2. In your map from FF schema to SQL schema, add a looping functoid linking your CSV record to the SQL record.
I have a csv file with multiple transactions/Records that I need to upload into a SQL database using a BizTalk Orchestration. I have created a flat file schema for the csv file. The csv flat file schema is then mapped to a schema that inserts the data into SQL table using a stored procedure using WCF SQL adapter. The only issue that I’m having is that only one record is being uploaded. There must an easy way of uploading all these records without writing a custom pipeline. I have tried to look at the various properties of the flat file schema i.e envelope property as advised in some texts but it doesn’t work and also using functoids. There must be a easy way of doing this. Thank you for the response.
Author
Posts
Viewing 2 reply threads
The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.