Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · C# Training Videos · SQL Server Video Training
   
Visual Basic Training Videos
Visual Basic Video Tutorial Home  Subscriber Videos  

Visual Basic Tutorial: Pt. 2 - An Overview of How to Execute SSIS Packages With C#

   Chapter: Misc Topics That Don't Fit Anywhere Else
Download! Skill Level: 400 (Intermediate - Advanced)
Duration: 12:15
Size: 13.0MB
Versions/Editions Covered: SQL Server 2005 , SQL Server 2008 , SQL Server 2000
Added/Updated: Sep 26, 2007

Download this video
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
Tags for this video: .net C# in process package execution remote package execution  
< Back Download this video
People Who Downloaded this Video Also Downloaded:
TitleSkillDownload
Pt. 1 - Getting Started With Your First ASP.NET Website in Visual Basic 200 Download
Pt. 2 - Adding Objects and Working With Events, Properties and More 200 Download
Pt. 1 - Creating the Project, Adding Items to the WinForm and More 100 Download
Pt. 4 - Using Gridviews, SQL Server 2005, and Hacking Your Textboxes 300 Download
Pt. 3 - An Overview of the Toolbox and Design-Time vs. Runtime 200 Download
This video is part of the following video series: "A Tour of the Various Ways to Execute an SSIS Package Outside of BIDS and SSMS"
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.
To view all videos in this series, click here

About the Instructor:
Scott Whigham Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/5/2009 11:11:49 PM