In this video (Execute SQL Task in SSIS) we are going to learn how to use Execute SQL Task in SSIS to run the SQL Queries on Microsoft SQL Server Database. First we will run a hard coded query on the database and then we will see how to run the dynamic queries on database syste. In this video tutorial we have seen 4 method to dynamically execute the SQL query on the database system.
Register for our FREE Live webinars –
You can purchase the course The course has all my youtube videos nicely arranged in modules. Each lesson has SSIS package to download and practice on your own.
This is our another tutorial video on SSIS topic. In coming days you will see more videos from our side on MSBI stack and on SQL Server.