SSIS Tutorial Part 51-Dynamically Change the SQL Command in OLE DB Command Transformation
Автор: TechBrothersIT
Загружено: 2015-05-06
Просмотров: 25303
We have multiple tables with same structure for customers for each region. We have this requirement to build an SSIS Package that will read the data from flat file and then load the data depending upon the name of file. After loading the data to specific table, it will also update the records in history table. History Table follow the same meta data and name has _Hist at the end.
What you will learn by watching this video
How to create SQL Server Tables by using Create Statement
How to Insert Rows for testing purpose in SQL server Tables
How to Create an SSIS Package from basics
How to use For-each Loop to read Multiple Files from a Folder Path Variable
How to use Data Flow Task to read Flat file Source And perform Data Conversion
How to use Variable in OLE DB Destination to change the name of Destination table dynamically
How to Change the update Query for OLE DB Command Transformation Depending upon File Name
How to write Expressions on Data Flow Task as well on Flat File Connection Manager
Blog post link for scripts used in this video
http://sqlage.blogspot.com/2015/05/dy...
Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
http://www.techbrothersit.com/2014/12...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
