I am still in testing stages on a lab server trying to build an application. Presently I am looking at the possibility (extremely high one at that) of pulling upto 9 Millions records. I will be pulling them from a SQL Server database, applying business rules, and then exporting them as a single file (or set of a dozen broken by a code) to CSV style format.
Is BizTalk built to even come close to pushing 5-10 million records from a SQL Server to a Flat File in say 2-3 hours?
I know there are a lot of unknowns… but in theory is it possible? Are you likely talking 1 server, 10 servers? I will not hold anyone to it… just trying to evaluate and decide if other options than BizTalk should be persued.
Thanks.