SSIS Code Check Extension features

1. An editor extension that checks SSIS Packages and SQL code against industry best practices  

2. Below are some of the rulesets validated by tool for SSIS Package:

   • Check naming convention for Containers, Tasks, Sources, Destinations

   • Check for duplicate connections

   • Check if delay validation property is set

3. Below are some of the rulesets validated by tool for SQL Code:

   • Use table aliases and refer to column names using that alias

   • Use WITH (NOLOCK) for selecting or deleting rows from a table

   • Avoid use of subqueries in JOIN statements

   • Follow Pascal case for variable/table/views/stored procedure names

   • Use CONVERT() instead of CAST()

   • Create Table/Primary Key/Clustered, Non-Clustered Index/ only on DATA File Group

How to execute SSIS Code Check Extension

• After successful installation of SSIS Code Check Extension, it will be visible under your Visual Studio ribbon

• Click on SSIS Code Check -> Execute SSIS Code Check. You should have SSIS Package open in the IDE for the extension to report warnings

• Warnings are displayed in the output window:

• Fix these warnings to be aligned with Industry development standards