SSIS Tutorial Part 121-Reject Already Loaded Files & Load Only New Files to Table in SSIS Package
Автор: TechBrothersIT
Загружено: 2015-04-29
Просмотров: 28562
SSIS Video Scenario:
We get the files from our client that we need to load on daily basis to SQL Server Table. Sometime there are chances that the client might provide the same file again. In that case we want to move that file to Rejected Folder and don't want to load. If any new file will be received in the folder, we will load that after confirming the file is not loaded already.
What you will learn in this video
How to read the files from Folder by using For-each Loop Container
How to Log the file name into the SQL Server Table for validation
How to Check if file is already loaded. You will build your query in Execute SQL Task by using Expressions
How to use File System Task to move file from Source To Reject Folder in SSIS Package
Move the new file to Archive folder after loading first time by using File System Task.
Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/04/ho...
Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
http://www.techbrothersit.com/2014/12...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
