SSIS Tutorial - Execute SQL Task

preview_player
Показать описание
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.

In this SSIS Tutorial we talk about the Execute SQL Task within the Control Flow, along with the Data Flow Task this will make up 90% of what you will need to do in terms of an ETL process.

We discuss examples on how we can use the Execute SQL Task to Truncate Tables, Execute Stored Procedures with Parameters and run a SELECT statement and return a result set.

This SSIS Tutorial doesn't discuss how to create connection managers, if you are new to SSIS and would like to learn how to create connection managers check out the below videos on my channel:

If you are interested in watching all tutorials and videos on SQL Server Integration Services then check out the playlist available:
Рекомендации по теме
Комментарии
Автор

the golden grail of English accented youtube tutorials

mycollegeshirt
Автор

Brad: As you point out, the SQL box is difficult to use and creates oddly formatted SQL code. Is it possible to create the SQL in SSMS or even Notepad, copy the code, then paste it into the SQL box?

houstonvanhoy
Автор

Thank you for the informative video! Is there any chance you are going to be making one on how to access Execute SQL task result set saved as a variable in another SSIS task?

yuliathonippara
Автор

Hi,
Is it possible that we create Execute SQL task and then export that data in csv format directly to FTP using FTP task? If there is some video on such kindly share link.
Thanks !

asadnaseer
Автор

There are so many options in SSIS. Hard to remember all of them

naheliegend
Автор

Hello mate, just wondering if there is an email I can contact you, for some advise. as I am preparing for MS 70-767 and plannin to crack in to Data Industry, I dont have a Data background but do have some web development background. Many Thanks

raymonds
Автор

my friend i want to enter ddmmyyyy date to db from flat source but doesnt accept it any solution?

john_yeager
Автор

The yellow circle over the mouse arrow a bit distractive. Thanks.

larryc