I need help in handling an error which occurs when importing data in a temporary table.
The error message is the following:

"OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory"

This error does not occur every time I try this importation, but just after few operations of the same kind. After the error has been detected, I cannot try any further importation unless I start again the SQL Server on the Server.
I must say I'm importing a huge amount of data using the following query:

"SET DATEFORMAT MDY SELECT * INTO ##tmpNew FROM LinkedServerName.DBName.DBO.TableName"

As anybody can see, I'm importing these data from a tables which belongs to another DB on another Server, linked to mine main server...

Hope my explanation was clear enough.
Looking forward to finding a solution.