How to Save Single Value in a Variable in Execute SQL Task ( Single Row Result Set) -SQL Server Integration Services Tutorial

Scenario:

The company we work has multiple processes running every night. After completing all of the process a Flag it set to YES,No Or Pending in SQL Server Table. We need to create an SSIS Package that read this flag value and then Run Required Tasks according to the flag value that is stored in SQL Server Table.

Items we will leaven in this video

• How to Create SQL Table with Flag Column
• How to create Variable in SSIS Package to hold Flag Value 
• How to save Flag value into Variable by using Execute SQL Task ( Result Set Single Row)
• How to use Precedence Constraint in SSIS Package to Control the Flow of Tasks Executions
• Find out If expressions in Precedence Constraint are Case Sensitive or Not in SSIS Package

Script used in the video demo to Extract Single Value from a Table by using Execute SQL Task ( Single Row ResultSet) and handle Flow of Tasks in SSIS Package.

--Create Table to Hold Flag Value
Create table dbo.StatusFlg(Flg VARCHAR(10))
go
insert into dbo.StatusFlg values('YES')

--Check the Flag value 
Select Flg from dbo.StatusFlg

--Update the Flag Value for Testing an SSIS Package
update dbo.StatusFlg
set Flg='Pending'

How to use Single Row ResultSet in Execute SQL Task  in SSIS Package - SSIS Tutorial

 Related Posts / Videos on Execute SQL Task  

• Execute SQL Task Demo for Max Size of SQL Statement in Execute SQL Task Query Editor and Solution
• Execute SQL Task Demo- How to Build Dynamic SQL Query to Execute Multiple Stored Procedures those names are saved in a SQL Server Table
• Execute SQL Task Demo - How to Execute SQL Queries from a SQL Server Table in SSIS Package ( SQLStatementType= Variable)
• Execute SQL Task Demo - How to Execute SQL Queries from Excel file in SSIS Package ( Record Set Destination, Object Type Variable and Foreach Loop Container Demo as well)
• Execute SQL Task Demo - How to use Insert Query in Execute SQL Task and Map the variables to Parameters ( Insert File Name and Record Count after Loading the File).
• Execute SQL Task Demo - How to use Stored Procedure with Input/Output Parameters in Execute SQL Task in SSIS Package( Load File Name, Package Name , Record Count and File Load Time in SQL Server Table).
• Execute SQL Task Demo - How to build Query by using Variables in Execute SQL Task ( File Name validation and move files to Archive folder and Bad File Folder if does not validation correctly)
• Execute SQL Task Demo - How to use Full Result Set in Execute SQL Task ( Get Folder Path and File Names from SQL Table and Load those files)
• Execute SQL Task - How to Load Files from Specific Folder Paths Saved in a SQL Table By using SSIS Package
• Execute SQL Task ( use Variable value in Expressions Demo) - How to Reject Already Loaded Files and Load Only New Files in SSIS Package
• Execute SQL Task ( Handle Single Row Result Set Blank Error) -Single Row result set is specified, but no rows were returned in Execute SQL Task in SSIS Package
• Execute SQL Task ( Save Result Set to Variable Demo) - How to Return Deleted and Update 
• Record Count from Execute SQL Task and Write to Flat File in SSIS Package
• Execute SQL Task ( Build Dynamic Query in Variable and use as Source ) - How to Save Query in Variable and Use in Execute SQL Task 
• Execute SQL Task Expression's Demo - Using Variable in IF Clause in Execute SQL Task in SSIS Package
• Execute SQL Task ( Parameter Mapping Demo for Stored Procedures) - How to Run multiple Stored Procedure in Execute SQL Task with Input Parameters
• Read Single Cell Value from an Excel File in SSIS Package