error while importing text file into sql server 2000

hi all,

While importing into sql server 2000 from a text file i am getting an error message like not enough disk space available to perform this operation but there is enough space (around 18gb). Please advice why this is happenning as my work is stuck

thanks and regards

jk

This is a guess since you didn't give much detail, but try setting your BLOBTempStoragePath and BufferTempStoragePath properties to a location on the drive where this 18GB is available. These paths default to the drive where SSIS was installed, which is usually a system drive and may be close to full.
|||

thanks for the reply , could u please explane it in details as i am new to sql server 2000 the problem i am facing is that , when i try to import a text file into a DB it is showing ERROR 'not enough storage space.'

The text file is been exported from another DB using some date constrains. I have tried restoring DB just to check weather this is because of storage space problem but it works fine but when i try to import data the above error is shown . Please advice

thanks and regards

jk

|||This no longer sounds like a SQL Server 2005 Integration Services question. If it is, please provide details about your scenario and error. If not, you're probably best served by doing some web searches first and then posting your question in a more appropriate forum.