New Visual Basic Video Tutorial: Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic

Pt. 3 - An Overview of How to Execute SSIS Packages With Visual Basic - view details

This video is for those people wanting to see a quick intro to the basics of executing SSIS packages with Visual Basic. 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 Visual Basic?
  
• What DLLs do I need to reference in my Visual Basic 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 Visual Basic - stored in the msdb SQL Server database
• How to execute a file-based SSIS package in Visual Basic

and much more

---

• Source: http://www.LearnVBProgramming.com
• Category: Misc Topics That Don't Fit Anywhere Else
• Skill Level: 400 (Intermediate - Advanced)
• Length: 15:00 (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, VB.NET, Visual Basic