I have dbf files from which data are to be transferred into SQL Server using BizTalk. Transferring of all the data into SQL Server takes about 10 minutes.
My question is, if any application tries to read records from the destination table while the data are transferring, then will sql server show transferred records?
Depends. How exactly are you inserting the data into SQL. Are you using an updategram? Are you ecursively calling a stored proc? Are you calling a stored proc once with all the data?
Author
Posts
Viewing 1 reply thread
The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.