SSIS: DBSTATUS_UNAVAILABLE
Scenario: Your SSIS package fails and you see error messages in your log files along the lines of
Description: Failed to retrieve long data for column “xxxxx”.
End Error Error: 2010-03-03 16:30:02.84 Code: 0xC020901C Source: Data Flow Task 1 Source – Query [1]
Description: There was an error with output “OLE DB Source Output” (11) on component “Source – Query” (1).
The column status returned was: “DBSTATUS_UNAVAILABLE“.
You will probably find that the column “xxxxx” is something like a text or picture data type (i.e. BLOB or similar) and what’s happening is that SQL Server is either running out of Disk Space to store this stuff.
Step one is obviously to check if you actually need all this data and optimise your dataflow by removing any unnecessary columns.
If you can’t do that, try setting the BLOBTempStoragePath and BufferTempStoragePath to Fast Drives, or at least drives with more disk space.
See these posts for more details
http://connect.microsoft.com/SQLServer/feedback/details/346675/ssis-runs-out-of-temp-file-names
