Cannot create new transaction because capacity was exceeded

I used One Begin trans in OLE DB command and executing 30+ insert statement. But some times it gives error message “Cannot create new transaction because capacity was exceeded” Error code:-2147168227. (Not always)

Will you please help me to resolve this and let me know why it happenes?