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 2008: insufficient disk Expand / Collapse
Author
Message
Posted Wednesday, April 9, 2014 5:12 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:34 AM
Points: 107, Visits: 355
Hi All,


Executed as user: --. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:00:02 AM Error: 2014-04-08 07:13:53.20 Code: 0x800705AA Source: dbo.TestDetails Description: End Error Error: 2014-04-08 07:13:53.43 Code: 0xC004704B Source: dbo.TestDetails Description: The buffer manager cannot write 8 bytes to file "T:\Windows\Temp\DTS{7BA097F6-DC45-4A49-B1E4-1824946D0F2B}.tmp". There was insufficient disk space or quota. End Error Error: 2014-04-08 07:14:45.69 Code: 0x800705AA Source: dbo.TestDetails Description: End Error Error: 2014-04-08 07:14:45.69 Code: 0xC004704B Source: dbo.TestDetails Description: The buffer manager cannot write 8 bytes to file "T:\Windows\Temp\DTS{44CBA3AE-1C3A-4A64-AFB0-02C2E748A86D}.tmp". There was insufficient disk space or quota. End Error Error: 2014-04-08 07:15:56.06 Code: 0x800705AA Source: dbo.TestDetails Description: End Error Error: 2014-04-08 07:15:56.06 Code: 0xC004704B Source: dbo.TestDetails Description: The buffer manager cannot write 8 bytes to file "T:\Windows\Temp\DTS{3927E2A2-A4E1-45C0-81B9-33941CC0D4BB}.tmp". Description: The Data Flow task failed to create a buffer to call PrimeOutput for output "OLE DB Source" (1) on component "OLE DB Source Output" (11). This error usually occurs due to an out-of-memory condition. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:00:02 AM Finished: 7:23:54 AM Elapsed: 1431.79 seconds. The package execution failed. The step failed.
-----------------------
I am getting above error when running SSIS package through job. The error was saying "insufficient dis space", when I checked T drive have 400 GB free space. I could not find what was the problem. Please help me on this.

Thanks,
Arooj

Post #1559876
Posted Wednesday, April 9, 2014 10:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:57 AM
Points: 1,194, Visits: 2,234
This error usually occurs due to an out-of-memory condition.


Check if you are experiencing any memory problems and errors ..

--
SQLBuddy
Post #1560054
Posted Wednesday, April 9, 2014 11:33 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 5,315, Visits: 12,344
sqlbuddy123 (4/9/2014)
This error usually occurs due to an out-of-memory condition.


Check if you are experiencing any memory problems and errors ..

--
SQLBuddy


Note also that SSIS may do some caching to the TEMP folder (as defined in the PATH for the server), which is likely to be on the server's C: drive. Not always what you want ...



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1560249
Posted Wednesday, April 9, 2014 11:58 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:00 AM
Points: 856, Visits: 1,505
This is Link
Post #1560252
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse