I am troubleshooting a memory allocation issue with an SSIS package and came across the following article. It is a couple of years old, but still very relevant:
Integration Services: Performance Tuning Techniques
SQL Server
...now browsing by category
Good reference on SSIS tuning techniques
Wednesday, September 2nd, 2009Missing SQL Server 2008 templates in Visual Studio Team System 2008 Database Edition
Tuesday, September 1st, 2009I have a new install of Visual Studio Team System 2008 Database Edition that is updated to SP1. I went to make a new SQL Server 2008 project and noticed that there was not a template available. I thought this was odd as I have SQL Server 2008 installed locally. After a little research, I was pointed to the following update: Microsoft® Visual Studio Team System 2008 Database Edition GDR R2. After closing VSTS and installing the update file, I restarted VSTS and the templates were there.