10 SSIS Best Practices for Package Development

Kuldeep Chauhan (Kuldeepc) lists 10 best practices for SSIS Package Development.

Includes tips on

• Package Re-usability
• Naming Conventions
• Data Access Modes
• Data Sorting
• Package Protection Level (why the default of EncryptSenstiveWithUserKey may not always be the best option
• Value of the Sequence containers
• Checkpoints and
• The Execute SQL Task.