All geek questions in one place

SSIS OLE DB Source - Cache Move

When the SSIS package is started by the scheduler on the server, the C: drive becomes full, and the calculation fails with an error. Failed to get long data for column "Col1" .

The package has 3 steps:

  • The source of the OLE DB is to retrieve the entire binary data table - this step is not performed.
  • Script Component - calculates a hash of each information
  • The purpose of OLE DB is to save the hash in another table

If I run the sql script from 1) in SQL Query Management Studio, it is not with the error: "An error occurred during the execution of the package. Error message: there is not enough disk space."

Is it possible to move any caching of this particular package to another drive? Or move the caching of all packets to another drive?

Another drive I call a drive where no SQL Server is installed, nor SQL Server data is saved.

Change tools> Parameters: query results> SQL Server> General. The default location for saving query results in Management Studio did not help.

thanks

+4
source share
1 answer

When you go to the "Data Flow" tab, right-click anywhere, not on the task, and select properties. There will be two elements

BLOBTempStoragePath

BufferTempStoragePath

You can change the location there.

+3
source

Source: https://habr.com/ru/post/1625299/

More articles:


All Articles