i got the same error..

When i execute dts package, sometimes i get this error:

"Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description1:UNISUB-SIPARIS_S2O) SubStep 'DTSStep_DTSDataDrivenQueryTask_1' failed with the following error:

Not enough storage is available to complete this operation.

 (Microsoft Data Transformation Services (DTS) Package (8007000e): Not enough storage is available to complete this operation.

) (Microsoft Data Transformation Services (DTS) Data Pump (8007000e): Not enough storage is available to complete this operation.

)

Package failed because Step 'DTSStep_DTSDataDrivenQueryTask_1' failed.

Step Error code: 80040428

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:1100"

I delete package and create again,Package executes correctly 4-5 times, then again the same error message.I need help.. (Did you find solution)