执行Integration Services作业时，由于空间不足导致失败

Question

在使用Integration Services 时,因为数据量过大、C盘的空间不足导致作业执行失败。请问在哪里可以修改缓存地址，将默认的C盘改为其他分区？

Answer 1

Try set temp folder to other disk in your profile.

Answer 2

Sorry, you can tell me where to set the temporary folder? SSIS in SQL SERVER and I can not find.

Answer 3

That's one of windows environment variables, change that in machine properties -> advanced -> environment variables on the machine where you run the package.

Answer 4

Thank you, I understand, thanks