I am facing a memory problem on my development server.
I have 12.5 GB RAM available. During any SSIS run the memory drops to less than 1 GB and never recovers after the run is completed. I am overcoming this by restarting the sql service or restating the server machine; which will free the memory unto 11 GB. Sadly, after any other SSIS run the memory drops again to 1GB. Kindly advice how to overcome this headache.