Eccovi una top 10 delle best practices molto utili quando si creano pacchetti SSIS: http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx