SQL Server Performance

Interesting Package Error

Discussion in 'SQL Server DTS-Related Questions' started by Jeffrey_D_York, Nov 1, 2005.

  1. Jeffrey_D_York New Member

    Good Morning all-

    I am recieving the following error which I haven't seen before. It happens during a transform/pump from a flat file into a DB. It had been working previously. It seems, however, to be system wide as I tried a DTS between 2 DB's and got the same error.

    Error Source: Microsoft Data Transformation Services (DTS) Data Pump.
    Error Description: There is not enough storage available to complete this operation.
    There is not enough storage available to complete this operation.
    There is not enough storage available to complete this operation.

    I have a 4 GB TempDb with nearly all of it available.


    Any help is appreciated. Thanks!
  2. Argyle New Member

  3. thesushil New Member

    I am also higly troubled with this error.

    I am sure I have enough memory and harddisk space.
    Also I m using ms sql server 2005, microsoft accepted that it was a bug in mssql 2000, I expect they got rid of the bug in 2005 version.

    Also I cant understand the solution in the link, how do I avoid the lookups while importing data from flat file?

    Any help will be greatly appreciated !!

    thanx in advance
  4. ekb18c New Member

    I read somewhere that someone was having those issues on a new box as well and it turned out to be 1 bad processor.

Share This Page