How to Deploy SSIS Packages: SSIS Package Store, File System and msdb Deployment - Video Series Video Category: Package Management - Security, Storage, Logging and Change Management Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 One of the most confusing/different things in SSIS is how you deploy a package. It was easy in SQL Server 2000's Enterprise Manager: You just went to File-->Save and you saved the package in either SQL Server or as a .dts file. ahhhhh, don't we pine for the simple approach? Today you have a phalanx of options: you can save your packages as a .dtsx file individually, (2) you can save your packages as a .dtsx package as part of a project/solution, (3) you can save your packages in the SSIS Package Store (What? What's that?), or (4) you can store your packages inside the SQL Server in the msdb database. What's the difference? Which one should you choose? That's what this series is all about!

Videos in this Series:

Title Skill Length Download Pt. 1 - An Overview of Package Deployment Options: File System and msdb Storage   300 10 mins. Download Pt. 2 - What is the SSIS Package Store and How Can I Configure It?   400 11 mins. Download Pt. 3 - Organizing Packages With Folders in the SSIS Package Stored and msdb; Fi...   400 9 mins. Download

< Return to list of all videos