Chris Hewitt-261101 (4/19/2013)
Hi thereWhen running an SSIS package I get the following message:
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Could not allocate space for object 'dbo.SORT temporary run storage: 140748109840384' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.".
I have checked disk space - plenty of it left
Tempdb is set to "autogrow"
Yet - still get this error.
Any ideas?
Regards
Chris
How much space is available on the drive where tempdb resides?