SSIS FTP writes big temp files to profile folder on C...

  • Hello,

    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.

  • Ken Davis (8/17/2012)


    Hello,

    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

  • Hi Ken,

    Can you check the following article?

    Post back your results.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • Thanks. I will be trying this. Actually I think I won't need that article's Solution 1 or Solution 2. I can logon to the server with the SQL account so I should be able to change the IE cache location. That may be just what I needed.

  • That worked like a charm. I logged on to the server with the SQL process account and changed the IE cache folder to a larger drive. Thanks for the tip.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply