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: Monday, March 10, 2014 12:52 PM
Points: 139, Visits: 381
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: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1353054
Posted Tuesday, September 04, 2012 8:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:04 PM
Points: 1,114, Visits: 2,192
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 04, 2012 1:10 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, March 10, 2014 12:52 PM
Points: 139, Visits: 381
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 05, 2012 8:06 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, March 10, 2014 12:52 PM
Points: 139, Visits: 381
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