Error " Failed to allocate bindings memory."

[sajan]

Hello everybody,

I have two problems :

The first problem:
I have this error when i try to execute my job :
"Failed to allocate bindings memory."

The second problem:
When i use in my stage OLE/DB the provider=SQLOLEDB.1 the job failed and when i use MSDASQL.1 the job run whitout error.
For information, i have others jobs where the provider SQLOLEDB.1 and they run whitout problem

Can you help me please ?

Thank you very much.

[ray.wurlod]

Welcome aboard.

For problem 1 looks like you're exhausting available memory. Do you monitor memory consumption, for example with Task Manager or with Performance Monitor, on the server?

For problem 2 there is obviously something in that particular job that is incompatible with provider SQLOLEDB.1 - but without seeing the warnings that were generated it is impossible to diagnose further. Why don't you inspect the job log and see if there's anything obvious logged there?