BizTalk SQL Adapter Max Records It can handle

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk SQL Adapter Max Records It can handle

Viewing 1 reply thread
  • Author
    Posts
    • July 9, 2009 at 3:23 PM #22827
      community-content

        Does anyone know how many records (lets say 1 kb per record) BizTalk SQL Adapter can handle? I would like to read 4000 records from one database and after processing it in BizTalk, insert those records to another database using SQL Adapter. What would be performance impact? Or is it better to use flat-file as input and dump flat-file as output and let source and destination application deal with database operation (read and write to the tables)

        Regards,

        Ray

         

      • July 10, 2009 at 5:34 AM #22828
        community-content

          alternative you can use SSIS

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