New Visual Basic Video Tutorial: Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell

Pt. 7 - More on DTEXEC; How to Execute SSIS Packages In Windows PowerShell; Using xp_cmdshell - view details

This video covers a ton of material - a little more on DTEXEC, some good info about how to execute an SSIS package in Windows PowerShell, and then the finale: how to execute packages from Transact-SQL.

Highlights from this video:

• What syntax errors are common in PowerShell when you execute SSIS packages and how to fix them
  
• Should you use T-SQL to execute SSIS packages?
  
• What are the pros and cons of using DTEXEC vs. TSQL?

and much more

---

• Source: http://www.LearnVBProgramming.com
• Category: Misc Topics That Don't Fit Anywhere Else
• Skill Level: 400 (Intermediate - Advanced)
• Length: 15:30 (12.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: xp_cmdshell, Surface area configuration, security