0

How do we improve the coding standards of SSIS packages?

Is there any code review tool within Visual Studio that helps to improves the standards of queries and tasks used in the SSIS package?

For Example, we have an execute SQL Task(naming convention not followed) and have written SQL complex query with poor coding standards.

In this scenario, is there any tool within Visual Studio that helps to give a review report and help to improve coding standards for SQL queries and naming conventions for Tasks?

We have tools like SQL Enlight, but it's available only within SSMS, We have SSIS code check-in VS, but it won't review codes within the tasks.

please let me know if there is a combined tool within VS to review

Thank you

Hadi
  • 36,233
  • 13
  • 65
  • 124
Unknown
  • 21
  • 1

1 Answers1

0

You can check the Visual Studio for a code check extension such as SSIS Code Check

Also, it is good to create unit tests for the SSIS packages: How do I unit test and integration test my SSIS packages?

Hadi
  • 36,233
  • 13
  • 65
  • 124