SQL Server Performance Forum – Threads Archive

Interesting Package Error

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!

According too:
http://groups.google.se/group/micro…read/thread/3233f2d068692f70/90e5309c22810e2b it might be a bug with lookups in transformation steps. A workaround is to rewrite the package to use staging tables instead.

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

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

]]>