SSIS Tutorial Part 53-Use Dynamic Query in Lookup Transformation in SSIS Package

Channel Avatar
Comment
X
Share
SSIS Tutorial Part 53-Use Dynamic Query in Lookup Transformation in SSIS Package
SSIS Tutorial Part 53-Use Dynamic Query in Lookup Transformation in SSIS Package
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/how-to-use-dynamic-query-in-lookup.html

Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
http://www.techbrothersit.com/2014/12/ssis-videos.html

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: Lookup Transformation in SSIS Package, SSIS Package, SQL Server Integration Services Interview Questions and Answers, SQL Server 2014, SSIS, Database, MSBI, Business Intelligence, Business Intelligence Tools, ETL Tools, SQL Server development, SSIS 2014, SSIS Tutorial for beginners, Tech Brothers, Real Time SSIS Scenarios and Solution, Lookup Transformation Dynamic Query in SSIS Package, SSIS Realtime Training, Tech Tutorial, Programming

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *