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.
