SQL SSIS Best Practices

I’m wanting to compile a basic best practices list for SSIS. I don’t really need to get into tons of details for my list, I really just want to say have the big 10 DO and the big 10 DO NOT. Here are my sources for research so far.

http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ssisperfstrat.mspx” http://blogs.msdn.com/ashvinis/archive/2005/09/27/474563.aspx http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/ http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspx

additionally, here’s a cool little tip/trick about dynamic sql in ssis.

http://blogs.conchango.com/jamiethomson/archive/2005/12/09/SSIS_3A00_-Using-dynamic-SQL-in-an-OLE-DB-Source-component.aspx