dbTalk Databases Forums  

Not enough storage is available (-2147024882)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Not enough storage is available (-2147024882) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mike A
 
Posts: n/a

Default Not enough storage is available (-2147024882) - 10-01-2003 , 11:58 AM






When executing a DTS package via VB, I am importing a text
file into MSDE (less than 1GB of data) and I am getting a -
2147024882 error (Not enough storage is available to
complete this operation). I have Win2K SP4, MDAC 2.8 and
MSDE SP4. This use to work fine until the text file I am
importing grew by 30 fields or so. Any ideas?

Reply With Quote
  #2  
Old   
JI
 
Posts: n/a

Default Not enough storage is available (-2147024882) - 10-01-2003 , 01:26 PM






I am assuming there is enough hard drive space?

If so, check to see if there is a column limitation on
access. Seems like I have read there is a 179 column
limit. Verify this please.

Quote:
-----Original Message-----
When executing a DTS package via VB, I am importing a
text
file into MSDE (less than 1GB of data) and I am getting
a -
2147024882 error (Not enough storage is available to
complete this operation). I have Win2K SP4, MDAC 2.8 and
MSDE SP4. This use to work fine until the text file I am
importing grew by 30 fields or so. Any ideas?
.


Reply With Quote
  #3  
Old   
Mike A
 
Posts: n/a

Default Not enough storage is available (-2147024882) - 10-01-2003 , 02:31 PM



First off this is a delimited file (70 fields)
into MSDE 1.0 (SQL 7). My application works fine
for 15 thousand other customers but not this guy
and yes he has the disk space a goobs of memory.

When the field count was 40 we never had a problem.
Now, with it up to 70 I am experiencing some users
with this problem. However, updating there computers
to the latest OS SP, MDAC 2.8 and MSDE SP4 has fixed
all of them but this one guy.

I am having him try a new version where I
reduced the INSERTCOMMITSIZE from 1000 to 100
in the DTSDataPumpTask to see if that helps any


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.