Unix Technical Forum

SSIS, BIDS & Memory Use

This is a discussion on SSIS, BIDS & Memory Use within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> I have been having an issue where I run a small HR Headcount Fact Table build in SSIS for ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server Data Warehousing

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:10 PM
=?Utf-8?B?Q2hyaXN0aWFuIExvcmlz?=
 
Posts: n/a
Default SSIS, BIDS & Memory Use

I have been having an issue where I run a small HR Headcount Fact Table build
in SSIS for 50+ iterations. I slowly run out of memory. It appears that
BIDS is not releasing it. There is very minor custom code and all of it is
clean and calls dispose, etc. Are there any known issues with SSIS/BIDS not
releasing memory?

When my master package finishes runing, it stops with success but doesnot
free memory. It only relinquishes the 1GB of memory when I stop the debugger.

Thoughts? Help?
--
Christian Loris
http://www.implementsivillage.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:31 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com