Its a Fact transform so it has a number of lookups to dimension tables Interesting articule [regarding 64 bit], however non of the issues listed refer to buffer allocation - its mostly about database drivers Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx

I have a package that is failing and the error is: The buffer manager cannot write 8 bytes to file "C:\Users\XYZ~1\AppData\Local\Temp\DTS{2811E69C-65C7-4CEA-B03E-A13F8ECF75D0}.tmp". There was insufficient disk space or quota. I recently changed the sql agent job that calls it to explicitly use the 64-bit dtsx runtime but the problem now seems to be physical and not related to virtual memory Server drives have plenty of space Any idea how to troubleshoot this? Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx

what about C drive? does it extra free space there? what about user quotas ? is there any quota on user space? if above thoughts didn't helped, did you tried to run the job as 32 bit, in the job step, in execution tab, set the "run as 32 bit" to true and try again.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

C drive has plenty of space No quotas How would the job succeed as 32 bit if its failing as 64 bit? Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx

what tasks/transformations you used in the SSIS package? SSIS 64 bit has some issues, which listed here in todd's articlehttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

Did you tried to change Lookups Cache modes to no cache or partial cache? what was results?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com