Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayaseelan
Starting Member
6 Posts |
 Posted - 2008-10-24 : 00:19:57
|
| Hi,I am Executing an ssis Package in my local machine. The package comprises of a Dataflow task, The Dataflow task includes two OLEDB source,The property of both these two source is set to call two procedures respectively and the output of these two procedures is joined using Merge join, Then the resultant output of the merge join is written to a flat file destination.while Executing the package i am getting an error "The buffer manager cannot extend the file "C:\WINDOWS\TEMP\DTSB6.tmp" to length 10481764. There was insufficient disk space." please help me on this.. |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-10-24 : 01:02:35
|
| I'm not 100% sure of this, but on other ETL tools (Using AbInitio as an example), when you use similar components such as the Merge Join, it creates temp files on your hard drive with records sorted by whatever key(s) you're joining these records on, this space is then released after the process is completed.This probably means that your PC isn't powerful enough of running this package, so either you develop and run that at a Dev server or run on your local machine with a smaller dataset.I haven't done much work with the Merge Join on SSIS, but maybe there's a way to limit the amount of space it takes on your HD and I'll take a look at that tomorrow morning when I get to my office. On the other hand you should keep in mind that these Merge/Join/Sort components are really IO and space intensive and will always consume a lot of HD space, so, if running locally, try only running a smaller dataset.Hope this helps.---http://www.ssisdude.blogspot.com/ |
 |
|
|
|
|
|
|
|
Insufficient Disk space