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 Friday, August 17, 2012 1:28 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
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.
Post #1346728
Posted Friday, August 31, 2012 12:45 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:19 PM
Points: 7,127, Visits: 12,655
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
Post #1353054
Posted Tuesday, September 4, 2012 8:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 1,118, Visits: 2,224
Hi Ken,

Can you check the following article?

Post back your results.


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

Post #1353951
Posted Tuesday, September 4, 2012 1:10 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
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.
Post #1354136
Posted Wednesday, September 5, 2012 8:06 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
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.
Post #1354557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse