Post reply

SSIS FTP writes big temp files to profile folder on C

  • August 20, 2012 at 2:46 pm

    #262970

    My post below was not getting any bites in the SSIS forum so I'll try it here. Thanks for any thoughts...

    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.

  • August 21, 2012 at 3:23 am

    #1528002

    i dont know much about ssis, still

    "svcintersql" user's IE temp folder is the one you have specified that means, it is using default IE temp folder, might be the folders are not configured.

    kindly specify what does the temp files consists. if it is IE related(FTP used) hope you can clear the IE history.

    Regards
    Durai Nagarajan

  • August 21, 2012 at 7:52 am

    #1528132

    Thanks for the response. Yes, the FTP task within the SSIS package writes the temp files to the account's IE temp folder. I do not know why the temp files get written there. The task is doing FTP Gets for 3 files of banking data so that the data can be inserted to the database. If the task must write these temp files, I would like to configure the package to write them to a folder on another drive.

  • September 5, 2012 at 8:10 am

    #1533836

    This is resolved. Someone suggested I simply logon to the server with the account that runs SQL, open IE, and change the folder for Temp Internet Files to a larger drive. The SSIS FTP still writes the large files to the temp folder but I don't have a space problem.

  • September 5, 2012 at 8:35 am

    #1533870

    You could also set up a Windows Scheduled Task that runs a batch file or Powershell script to delete the temp files.

  • September 5, 2012 at 8:41 am

    #1533876

    Thanks for that thought. I do already have a final step in the SSIS job that deletes these temp files. My problem was, while the job ran, the C drive would almost run out of space. So I needed to stop the files from writing to C.

  • September 5, 2012 at 8:49 am

    #1533883

    Glad you managed to work it all out.

Viewing 7 posts - 1 through 6 (of 6 total)

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