hi all,
We have a requirement where bulk records will be coming from one SQL server database. BizTalk has to do the mapping (one to one with loop) and send the bulk records to another SQL server database using the composite schema.
We are able to receive and send successfully. But the problem came when we received 1 GB data from source SQL server database. We are able to receive the data but while sending from BizTalk to destination database, it takes ages and the instance is forever active.
We have tried to increase the send time out as well. But no use. After 3 retries (for some hours) the instance gets suspended.
Can anyone please suggest how to handle this?
Thanks and Regards,
Veena