New SQL Server Integration Services Video Tutorial: Pt. 3 - Introduction to SSIS Package Deployment

Pt. 3 - Introduction to SSIS Package Deployment - view details

How do you get an SSIS package "into" SQL Server 2005? Give up? It is quite confusing and one of the more common questions people have as they start looking at SSIS for the first time. If you want to schedule an SSIS package, there are several options but perhaps the easiest and most manageable technique is to (1) store the SSIS package in MSDB, and (2) schedule a job to execute the package. This video walks you through creating a "Deployment Utility" which is really just a euphemism for an XML file with a .SSISDeploymentManifest extension. If you double-click on the .SSISDeploymentManifest file, it launches the Package Installation Wizard that allows you to easily deploy an entire project's worth of SSIS packages. This is not the only technique but definitely the easiest way to deploy a series of related SSIS packages.

---

• Source: http://www.LearnIntegrationServices.com
• Category: Introduction to Integration Services
• Skill Level: 200 (Beginner - Intermediate)
• Length: 11:06 (14.4MB)
• Applies to Versions: SQL Server 2005
• 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: SSISDeploymentManifest, deploy ssis package, build SSIS package, schedule ssis package, ssis package job step, deploy .dtsx