What are the best practices for SSIS Configuration

By watching video you will be able to find the answer "What are the best practices for SSIS Configuration". The video discuss following below points


  1. Making a decision about type of SSIS configuration you should use?
  2. Naming your XML Configuration file or SSIS Configuration table properly
  3. Provide meaningful name to Environment Variable for Indirect SSIS Configuration.
  4. Save only required property values in SSIS Configuration file or SSIS Configuration Table. Avoid including any configuration which are not required and you never use them.
  5. Name your Configurationfilter meaningful and unique
  6. Reuse the configuration record if already available in SSIS Configuration table.
  7. Secure your SSIS Configuration files and SSIS Configuration table
Looking forward for comments for this topics so can include in best practices list.

2 comments: