Ken Davis (8/17/2012)
I have a complex SSIS package from a vendor. It includes an FTP task which moves files that total about 5gb. While the FTP runs, it writes copies of these files to the profile folder of the account that is running SQL, on the C drive. The specific folder is C:\Documents and Settings\svcintersql\Local Settings\Temporary Internet Files\Content.IE5.
These files have grown over time and now come near filling up C. Both the vendor and I have not found where to configure the folder for these temp files. That folder is not the actual destination of the FTP 'get'. I am working on moving this account's profile folder to another drive but I would really like to configure the SSIS package to write the temp files somewhere else. Does anyone know how to do that? Thanks for any ideas.
As far as I know there is not much you can do about the temp files being written. I ran into this when coding C# against one of the .NET classes in the BCL and I would not be surprised if SSIS used the same classes. It is a byproduct of some of the low-level Windows libs used to get files from a remote location.
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato