New SQL Server Integration Services Video Tutorial: Pt. 2 - An Overview of How to Execute SSIS Packages With C#

Pt. 2 - An Overview of How to Execute SSIS Packages With C# - view details

This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with C#. You'll learn about what DLLs to reference, what restrictions are on you, and how to execute packages in the SSIS Package Store, the file system, and the SQL Server (msdb).

Highlights from this video:

• Can I execute SSIS packages remotely with C#?
  
• What DLLs do I need to reference in my C# project to execute an SSIS package?
  
• Why does everything still say 'DTS'? I thought that was long gone...
  
• What's the difference between LoadPackage, LoadFromSqlServer, and LoadFromDtsServer?
  
• What's a DtsServer anyway?
  
• How to execute an SSIS package via C# - stored in the msdb SQL Server database
• How to execute a file-based SSIS package in C#

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Package Execution and Scheduling
• Skill Level: 400 (Intermediate - Advanced)
• Length: 12:15 (13.0MB)
• 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, .NET, C#