• Chris Hewitt-261101 (4/19/2013)


    Hi there

    When 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?