Part 2 of 2. This video on SQL Server Integration Services explains
1) What is SQL Server Integration Services (SSIS)?
2) Why use Extract Transform Load (ETL) tools like SSIS?
3) The basic building blocks of an Integration Services package. This includes Connection Managers and transformations such as Merge Joins, Sorts, Data Conversions, Aggregates, Conditional Splits, Union All, Pivots, Unpivots And Multicasts.
The tutorial also demonstrates how these building blocks are linked together in a live SSIS package. Links to various free learning resources are provided.
@assumeet : Glad you found the videos useful. Unfortunately I don't have the files for this demo any more (HDD failure). With subsequent videos, where possible, I am making the files available on my website on the associated post. Such as my introduction to T-SQL post etc.. Cheers Steve
stevefox1973 1 month ago
@chiranthk82 Glad you found it useful
stevefox1973 1 month ago
very nicely explained.
chiranthk82 1 month ago
Very useful video and series :)
Is it possible to get/download the text files you used in this video from somewhere?
assumeet 2 months ago