April 13, 2005 at 5:01 am
Hi All,
I have a DTS job failing with the following message
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory.
Couldn't get much help on searching.
Any suggestions/solutions on this would be greatly appreciated
regards,
phani
April 13, 2005 at 6:17 am
Take a look in the Windows Event viewer for that time fram under system and application. I suspect you will find an insufficient memory event. Sounds like you tried to pull more info into memory than you had physical memory and page file space total.
April 13, 2005 at 11:08 pm
I didn't find any events related to memory in either system or application logs.
April 14, 2005 at 11:08 am
DTS runs as a command line object, so it does not use the memory reserved for SQL Server, but the free memory on the system. You might try backing down the memory reserved for SQL, so the DTS jobs will have more to use.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply