SSIS Videos

Channels > SQL > SSIS

Video List

Adding a Time Stamp to a File Name in SSIS (Watch it Later!)

Date Published: December 01, 2008

Author: Brian Knight

Rating: 4.50

Description: This videos show you how to dynamically add a date stamp to a file name using SQL Server Integration Services expressions. It's a great example of how to set a property using an expression, with possible applications ranging far beyond just adding a date stamp.

	Executing SSIS Package in SSMS (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.29 Description: This video by MVP Brian Knight shows you execute an integration services package from the file system or from within Management Studio, and then it goes through most of the run time configuration options that can be applied to a package.

Parameterizing the Execute SQL Task in SSIS (Watch it Later!)

Date Published: December 01, 2008

Author: Brian Knight

Rating: 4.32

Description: It's easy enough to execute a statement using the Execute SQL Task in SSIS, but what about when you need that value to be conditional - maybe it needs to be based on the current date? You need a parameterized statement and SSIS has it's own way of doing it. Climb the learning curve a little faster with the help of SQL MVP Brian Knight as he does a 5 minute introduction to this feature.

	Scheduling SSIS Packages with SQL Server Agent (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.31 Description: This video shows you how to schedule an SSIS package within the SQL Server Agent as a SQL Server Job

	Using Data Viewers in SSIS (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.39 Description: Well known author and speaker Brian Knight shows you how to use Data Viewers in SSIS (Integration Services) to view data when your are debugging your SSIS packages.

	Using the File System Task in SSIS (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.24 Description: This video by MVP Brian Knight shows you how to use a File System Task in SSIS to rename, move or delete a file. If you have been using DTS, this task replaces most of the code you would have commonly placed in an Activex scripting task.

Using a Sort Transform in SSIS (Watch it Later!)

Date Published: December 01, 2008

Author: Brian Knight

Rating: 4.29

Description: SQL Server MVP Brian Knight demonstrates you how to use a sort transform to remove duplicate data and apply ordering to your data. The sort transform is an interesting alternative to TSQL for this task - after all, you may be working with data that isn't native to SQL Server.

	Using the Aggregrate Transform for Group Bys in SSIS (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.38 Description: SQL author and MVP Brian Knight demostrates the Aggregrate Transform in SSIS. Similar to a group by? Watch the video to find out!

	Using the TSQL Checksum Function (Watch it Later!) Date Published: December 01, 2008 Author: Brian Knight Rating: 4.32 Description: Brian Knight introduces the checksum function and demonstrates how to use it to determine that a column or an entire row has changed.

SSIS Stumpers V1 - Unpivot Example (Watch it Later!)

Date Published: June 27, 2007

Author: Brian Knight

Rating: 4.61

Description: In this series, Brian Knight shows you an actual difficult business problem to solve, gives you hints about how to solve it and then lastly shows you step-by-step instructions how to solve it if you want the help. You can download the sample code for this at http://www.endtoendtraining.com/private/misc/downloads.aspx. In this video of the series, Brian shows you how to unpivot data that may arrive from the mainframe and load a many to many table with SSIS.

Next -->