Tips for using SQL Server 2017 Integration Services (Part 2) Try to eliminate logging. Use logging during debugging and troubleshooting and eliminate unneeded logging when deploying completed packages to production. Use checkpoints to restart the package from the failed task instead of having to rerun the whole package. In SQL Server 2017 Integration Services a package that fails during execution…