Friday, September 28, 2007

New SQL Server Integration Services Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
and much more
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
and much more
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

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
and much more
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 4:35 AM  

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
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

posted by Scott Whigham @ 4:35 AM  

New Visual C# 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
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

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
and much more
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

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
and much more
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

posted by Scott Whigham @ 4:35 AM  

Thursday, September 27, 2007

New Visual Basic Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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, C#

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables syntax.
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: dts package, execute package

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services 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
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

posted by Scott Whigham @ 8:35 AM  

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
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

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
and much more
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 8:35 AM  

New Visual C# 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
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

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables syntax.
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: dts package, execute package

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables syntax.
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: dts package, execute package

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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, C#

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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, C#

posted by Scott Whigham @ 4:35 AM  

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
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

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
and much more
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

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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, C#

posted by Scott Whigham @ 4:35 AM  

New Visual Basic 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
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#

posted by Scott Whigham @ 4:35 AM  

New Visual C# 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
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

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET

Pt. 5 - How to Pass In Variables and Set Variable Values for SSIS Packages Using .NET - view details
This last overview-of-how-to-execute-packages-via-.NET video covers how to use variables: how to set variables in SSIS with Visual Basic and C#.
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, C#

posted by Scott Whigham @ 4:35 AM  

New Visual C# 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
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#

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
and much more
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

posted by Scott Whigham @ 4:35 AM  

Wednesday, September 26, 2007

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
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

posted by Scott Whigham @ 9:56 AM  

New SQL Server Integration Services Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
and much more
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

posted by Scott Whigham @ 9:56 AM  

New SQL Server Integration Services Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
and much more
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: dts package, execute package, msdb, sql agent, jobs

posted by Scott Whigham @ 9:55 AM  

New SQL Server Integration Services 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
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

posted by Scott Whigham @ 9:55 AM  

New SQL Server Integration Services Video Tutorial: Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe

Pt. 6 - More Options: Using DTEXEC.exe and DTEXECUI.exe - view details
Now that you've seen how to execute SSIS packages in .NET, you'll want to explore the other options. This video shows you how to execute SSIS packages from the command line using DTEXEC.exe and its GUI-counterpart, DTEXECUI.exe. This video also shows you how to set variables at the command line using the \Package.Variables syntax.
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: dts package, execute package

posted by Scott Whigham @ 9:54 AM  

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
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#

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic

Pt. 4 - An Overview of How to Override Event Handlers in C# and Visual Basic - view details
So now that you've got an idea of how to execute SSIS packages in .NET, you now need to learn about event handlers and the DefaultEvents in the Dts.Runtime.��
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, C#

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services 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
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

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS

Pt. 1 - An Overview of the Various Options for Executing SSIS Packages Outside of SSMS and BIDS - view details
This video, part one in this lengthy series, is an overview of several common techniques of executing Integration Services packages outside of BIDS (the Business Intelligence Development Studio a.k.a. the Visual Studio) and SSMS (the SQL Server Management Studio).

Highlights from this video:
  • What are the options for executing SSIS packages?
  • Can you execute packages with .NET (C#, Visual Basic, ASP.NET)?
  • Can I execute SSIS packages at the command line/DOS prompt?
  • How can I execute a SQL job remotely?
  • What is in-process and out of process?
  • What options are available for executing SSIS packages on a remote machine (i.e. how to execute an SSIS package remotely)?
  • What is SMO? How can it be used to execute an SSIS package?
  • Web Services? Huh? How can they help?
and much more
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

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: How to Setup a Windows Certificate Authority

How to Setup a Windows Certificate Authority - view details
Windows Certificate Services allows us to setup our own internal certificate authority so that we can issue digital certificates for internal applications. You typically do not want to use an internally-generated certificate for public-facing applications; your internal certificate authority will only really be used in-house (in your own company). This videos shows you how to install a local certificate authority which boosts your Windows Server security and your network security.

Highlights from this video:
  • Using Add/Remove Programs to add Microsoft Certificate Services
  • What are the various types of certificate authorities in Windows 2003?
  • Should I choose an Enterprise root CA, Enterprise subordinate CA, Stand-alone root CA, or Stand-alone subordinate CA?
  • Understanding the custom settings of certificates
  • Encryption options and key/value pairs in your CA (md5, SHA-1, etc)
and much more
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: security, md5, SHA-1