How do I configure DTS 2005 to not consume all the memory on my machine when processing large tables
I have 1 table that is particularly large and it causes DTS to run out of memory when it tries to extend its internal buffer during a sort merge.
Thanks!
Memory Configuration
Hot Topic
- Help
- Connect to Remote Analysis Server
- Client Agent Error: integrity violation
- creating a trace definition file (TDF) via code
- SSIS custom component will only partially update in VS causing debugging to fail
- 1:M JOIN 1:N
- update query and determinism
- Installation Problem
- viewing last table used (not modificated) date sql
- Updating Connection via VB.net
SQL Server
- SQL2000 Linked Server to Oracle
- System.Data from NETCF and System.Data from .NET
- PrimeOutput method error importing fixed width text
- Creating report based on parent-child dimension
- PackageID and GUIDs in ExecuteSQL task
- Installation of SQL server 2005 Developer Edition Sep CTP
- Problems with Printing and rendering to PDF
- Retieving ODBC Settings.
- Management Studio: connect again to load each SQL file
- SQL 2005 how to change @conflict_retention for articles already published
Memory Configuration
Bogdan B
Studio 2005 Beta2.050215-4400
.NET Framework 2.0.50215
Integration Services (Version 9.00.1116.00)
Dhori Alpesh
Miguel Gzz