HDTutorial
EN
SSIS Tutorial Part 26-How To Execute Multiple SQL Files by using SSIS Package

Playback starts YouTube’s embedded player (privacy-enhanced mode).

SSIS Tutorial Part 26-How To Execute Multiple SQL Files by using SSIS Package

37,089 views November 12, 2015 13:16

Watch on YouTube
ChannelTechBrothersIT

Description from the creator

In this video we are going to learn how to execute SQL files those are in folder by using SSIS Package.

This type of scenario is very common when you have a lot of script files sitting in a folder and you have to execute all of them.

In this video you will also learn
How to use variables in SSIS Package
How to use Foreach Loop Enumerator to loop through files in a folder
How to Map variables in Foreach Loop Container in SSIS Package
How to use Execute SQL Task in SSIS Package
How to write Expressions in SSIS Package

The demo video walk you through each step in detail and lead you to create your own SSIS Package that can be used in real time to run .sql files.


To Follow Step by Step this video tutorial
techbrothersit.com/2014/12/ssis-videos.html

About this tutorial

TechBrothersIT published this 13:16 video tutorial on November 12, 2015. It has been watched 37,089 times on YouTube.

Duration
13:16
Published
November 12, 2015
Views
37,089
Likes
127

Tags

Share

This tutorial in other languages