I have written stored procedure to poll the data from the database in biztalk.but the datasize is very large its around 80MB...Due to which i am getting error.Does anyone knows what configuration do i need to change to poll that much big amount of data.
in the table EDI834_5010_2300Loop i have around 35000 rows i need to chucnk the data depending upon this table
What do you mean by big amount of data? Big blob fields or many rows? If latter is the reason - modify your procedure to return data in chunks and set PollWhileDataAvailable = true in adapter.
In one of my current projects I use such procedure code to get data in chunks:
bts_DatabaseChanges is a log-table for all modifications in the DB.