Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS FTP writes big temp files to profile folder on C Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 2:46 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 12:25 PM
Points: 139, Visits: 384
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.
Post #1347482
Posted Tuesday, August 21, 2012 3:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1347653
Posted Tuesday, August 21, 2012 7:52 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 12:25 PM
Points: 139, Visits: 384
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.
Post #1347800
Posted Wednesday, September 5, 2012 8:10 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 12:25 PM
Points: 139, Visits: 384
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.
Post #1354562
Posted Wednesday, September 5, 2012 8:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:33 PM
Points: 359, Visits: 908
You could also set up a Windows Scheduled Task that runs a batch file or Powershell script to delete the temp files.
Post #1354600
Posted Wednesday, September 5, 2012 8:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 12:25 PM
Points: 139, Visits: 384
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.
Post #1354606
Posted Wednesday, September 5, 2012 8:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:33 PM
Points: 359, Visits: 908
Glad you managed to work it all out.
Post #1354616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse