Step by Step - SSIS Execute SQL Task - Part 5

In this fifth video of the series we explore how to use transact SQL queries with SSIS packages. We cover how to run store procedures and ad hoc SQL using the execute SQL task. We also look at how to pass parameters to stored procedures in order to dynamically change query results. The video also explains how to use the output from procedures to be cascaded to the next task. This is a critical aspect of building SSIS packages since not every task will have a corresponding integration services company to reliable.

Need more information?

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.

In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

You can also reach Jayanth via his LinkedIn profile below