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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 86, Visits: 250
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: Yesterday @ 11:19 AM
Points: 1,194, Visits: 2,215
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 @ 7:35 AM
Points: 5,024, Visits: 11,754
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.
Post #1560249
Posted Wednesday, April 9, 2014 11:58 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 682, Visits: 1,226
This is Link
Post #1560252
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse