Friday, May 04, 2007 9:45 PM royashbrook

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

 

Filed under: ,

Comments

No Comments