0
I have a SSIS project that loads almost big data in OLEDB Source component and with some changes, Insert them in another destination.
when I run this project with SSDT, It takes all of free space in C drive and never runs properly because of lack of space. (I can not add any more space in C drive and I have tried using its capacity in the most efficient way)
I am using SSDT not SSDT for Visual Studio component and it doesn't allow me to change its install location. I don't know how but one of my colleagues changed the visual studio location to D drive but still when I run this project, It takes all of C drive's capacity.
Any ideas about how to change SSDT location to another drive? or how to change the project's temp loading files in any other place?