Step Error Description:Not enough storage is available to complete this operation.

Question

Post reply

Step Error Description:Not enough storage is available to complete this operation.

Paul Bourg

SSChasing Mays

Points: 651
More actions
October 27, 2004 at 7:28 am

#61353

I have a DTS package that runs intermitantly. When I execute it from the local machine manually it executes successfully 9 out ot 10 time successfully. When I execute it as a scheduled task, it never executes successful. If failes with the below message on different steps of the update tables process. The whole message received is listed below. I am running a DL580 dual proc 1.4ghz 6gig of ram and 700 gig drive space. I haven't utilized the boot.ini switches as of yet. This DTS package is running against the RSExecutionLog database from Reporting Services.

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description: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.
)
Step Error code: 8007000E
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Any help would be greatly appreciated.
Thanks,
Paul Bourg
November 1, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

onur yilmaz SSC Enthusiast Points: 158 More actions · Answer 1

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)

Paul Bourg SSChasing Mays Points: 651 More actions · Answer 2

My solution was to recreate the DTS package and to single thread my queries. Executes successfully 100% now.

Paul Bourg

onur yilmaz SSC Enthusiast Points: 158 More actions · Answer 3

Could you explain "using single thread my queries in dts" ? How it changes?

.yilmazonur

Paul Bourg SSChasing Mays Points: 651 More actions · Answer 4

I had 7 queries that all executed at the same time. Once all queries finished an update statement was executed. I made one query the dependant of the other query all the way down to the last query. Then I executed the update statement after all queries were finished successfully.

Paul Bourg

KING COBRA Old Hand Points: 340 More actions · Answer 5

hi paul

jus try to clear the events in application log...

go to event viewer---action--clear events--dont save it wen u get a pop up for save..

make sure u hav the rights to clear the events..

i think it may solve u r problem

thanks...syed

Moin Ul Haque A Newbie Points: 7 More actions · Answer 6

Friends

Check this out.

http://support.microsoft.com/kb/889170

Regards

Moin.H

Regards
GOD BLESS YOU ALL
Moin.H

crabjoe SSC-Addicted Points: 468 More actions · Answer 7

I'm getting the same error and I know it's a problem with SQL 20000.

Last week when I ran the DTS with the same file on SQL 7, it loaded fine. I was forced to migrated to a different SQL server which has SQL 2000 (Old server is being decomissioned), and now I can't load the delimited text file.

Changing the commit size doesn't work and for some odd reason, I can't even do a BULK insert in Query Analyzer. BULK Insert says it completed, but nothing gets loaded into the table.!!

Rocky Grover SSC Journeyman Points: 80 More actions · Answer 8

Its known bug in SQl Server 2000.Evene one hotfix is there for solving this problem.this generally occurs when you are using look up queries in your package.this can be fixed by applying the hotfix.