Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Videos · SQL Programming Video Training
   
SQL Server Integration Services Training Videos
Integration Services Videos in Series Home  Subscriber Videos  

How to Deploy SSIS Packages: SSIS Package Store, File System and msdb Deployment (Video Series)

Video Image 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:



Other Websites We Offer
LearnSqlServer.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
12/5/2008 2:24:24 AM