SQL Server Behavior while Data Transfer

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Server Behavior while Data Transfer

Viewing 1 reply thread
  • Author
    Posts
    • #22168

      Hi all,

      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?

    • #22192

      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?

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.