A Tour of the Various Ways to Execute an SSIS Package Outside of BIDS and SSMS - Video Series Video Category: Package Execution and Scheduling Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 First - acronym definition time: BIDS is the Business Intelligence Development Studio and SSMS is the SQL Server Management Studio. Now - what does this series cover? This series is a high-level overview of how to execute packages outside of the normal BIDS and SSMS techniques of executing them interactively and through jobs. You'll learn the various techniques of executing such as .NET execution through C# and Visual Basic, using DTEXEC.exe, sp_start_job and SMO-based execution, and how to use web services with SSIS to execute packages remotely.

Videos in this Series:

Title Skill Length Download Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside o...   400 11 mins. Download Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Servi...   500 10 mins. Download Pt. 2 - An Overview of How to Execute SSIS Packages With C#   400 12 mins. Download Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic   400 15 mins. Download Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic   400 12 mins. Download Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using...   400 9 mins. Download Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe   400 12 mins. Download Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Usin...   400 16 mins. Download Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job   500 16 mins. Download Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More   500 10 mins. Download

< Return to list of all videos