New SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details

This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:

• What are the options for executing SSIS packages?
  
• Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  
• Can I execute SSIS packages at the command line/DOS prompt?
  
• How can I execute a SQL job remotely?
  
• What is in-process and out of process?
  
• What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  
• What is SMO? How can it be used to execute an SSIS package?
  
• Web Services? Huh? How can they help?
  

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Package Execution and Scheduling
• Skill Level: 400 (Intermediate - Advanced)
• Length: 11:00 (8.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: remote package execution, in process, package execution