Home Forums SQL Server 2005 SQL Server 2005 Integration Services Cache Transform (81) failed the pre-execute phase and returned error code 0xC0208246 RE: Cache Transform (81) failed the pre-execute phase and returned error code 0xC0208246

  • March 24, 2011 at 12:03 pm

    #1303144

    hmmm i dont see a 'MaxMemoryUsage' property in the Cache Transform property window.

    Within the Data Flow properties containing the Cache Transform there is the 'DefaultBufferMaxRows' and 'DefaultBufferSize' those are set to 10000 and 10485760...respectively.