New SQL Server Integration Services Video Tutorial: Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server ( Pt. B)

Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. B) - view details

In this fourth video in the series, Scott will really delve into the best practices on the package configurations table and discuss why those settings are optimal.

Highlights from this video:

• Problems with using the ConfigurationFilter defaults
  • Table logic
  • How to effectively run commands
  • Specifying PackagePath correctly
• Modifying the configuration table
  • Primary key
  • Indexes
    • Where to place an index

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Package Management - Security, Storage, Logging and Change Management
• Skill Level: 200 (Beginner - Intermediate)
• Length: 11:45 (10.5MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: package, configure, package configuration, best practice, table, configuration, sql, ssis.