New SQL Server Integration Services Video Tutorial: Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job?

Pt. 10 - How to Execute An SSIS Package in ASP.NET: Should You Use XML Web Services or a SQL Job? - view details

The final overview topic is on how to execute Integration Services packages with ASP.NET (C# and Visual Basic). This video covers the main choices and provides a nice wrap up at the end with suggestions for your own best practices.

Highlights from this video:

• What options are available in ASP.NET?
• What do local, remote and 'context' mean in SSIS?
• What accounts does ASP.NET use to execute the SSIS package in each instance?
• Should I use or consider ASP.NET impersonation?
  

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Package Execution and Scheduling
• Skill Level: 500 (Advanced)
• Length: 9:30 (10.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: sql server proxy account, job credentials, c#, visual basic, .net