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)