SSIS Tutorial Part 53-Use Dynamic Query in Lookup Transformation in SSIS Package
Автор: TechBrothersIT
Загружено: 2015-05-21
Просмотров: 40906
SSIS Tutorial Scenario:
We have a big reference table from which we need to extract records in Lookup so we can use against Source File. The table has the data from three regions AS,EU and NA. The files come with the name AS_FileName,EU_FileName and NA_FileName, Instead of extracting all the records for lookup , we want to extract the records according to the region Name. How can we perform that?
What we will learn in this video
How to create SSIS Package from scratch
How to Loop through files by using For-each Loop Container in SSIS Package
How to Read the part of File Name and Save into Variable by using Expressions
How to make use Variable to make Lookup Query dynamic in SSIS Package
How to filter the rows for Lookup Reference Data Set by using Variable Value
Link to the blog post for this video with script if used
http://sqlage.blogspot.com/2015/05/ho...
Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
http://www.techbrothersit.com/2014/12...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
