Overview Q & A Rating & Review
SSIS Code Check Extension features
An editor extension that checks SSIS Packages and SQL code against industry best practices
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
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