|
Date Published: June 13, 2010
Rating: 4.09
Description: The conditional split is an elegant transform - it lets you split data based on various expressions you write and send it to different destination (that may in turn 'fix' the data so it can be reintegrated back into the main stream. This video uses it to illustrate handling null/not null conditions AND reading/writing the output to Excel. For thos new to SSIS expressions, drag and drop is worth doing, the expressions are case sensitive!
|
|
|
Date Published: April 06, 2010
Rating: 3.92
Description: If you know the number of times a task is to be performed you can use a for loop container which is very similar to the for loop in programming languages.
|
|
|
Date Published: October 02, 2009
Rating: 3.87
Description: A great demonstration of using the Import/Export Wizard that uses SSIS for the actual moving of data
|
|
|
Date Published: April 15, 2009
Rating: 4.11
Description: The SSIS lookup transform is a great way to convert a literal like 'Florida' to something more database friendly like 'FL'. It's easy to use! Join SSIS expert Tim Mitchell for a simple demonstration of how to use this transform.
|
|
|
Date Published: April 15, 2009
Rating: 4.33
Description: Unfortunately, there are no native components in SSIS to support the secure (SFTP) transfer of files. This video will demonstrate an effective workaround use a free Secure FTP program.
|
|
|
Date Published: April 15, 2009
Rating: 4.32
Description: In an earlier video Tim gave a nice explanation of how to use the Lookup Transform, in this video he shows you how to deal with errors - cases where you have a state named 'Forida' that doesn't match to your lookup table.
|
|
|
Date Published: April 15, 2009
Rating: 4.36
Description: The expression language in SSIS is not quite C# and not quite TSQL, and it's case sensitive. But it's not hard to use once you get started, and Tim Mitchell has done a great job of helping you get started in this short video.
|
|
|
Date Published: January 28, 2009
Rating: 4.36
Description: This video shows you how to use the Database Tuning Analyzer (DTA) in SQL Server to help you make performance based changes to your database - especially helpful when you haven't quite mastered reading execution plans and you have a query that is performing badly.
|
|
|
Date Published: December 01, 2008
Rating: 4.51
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.
|
|
|
Date Published: December 01, 2008
Rating: 4.34
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.
|
|