In this scenario we want to handle a situation in which we might not get the results from our query that we have used in Execute SQL Task in SSIS Package. It is very common error that we get as we have use Result Set to Single Row and if our query does not return the results, we get an error in SSIS Package. Instead of error. We just want to stop the process with success.
Script used in the video to handle the situation when Execute SQL Task ResultSet is Set to Single Row and Query does not Return Row.
Create Table dbo.FilesToLoad
Script used in the video to handle the situation when Execute SQL Task ResultSet is Set to Single Row and Query does not Return Row.
Create Table dbo.FilesToLoad
( FolderPath VARCHAR(100), FileName VARCHAR(100) ) insert into dbo.FilesToLoad values ('C:\Users\Aamir\Desktop\InputFolder','Customer_AS_20150425.txt') Select FolderPath,FileName from dbo.FilesToLoad Truncate table dbo.FilesToLoad If exists( Select FolderPath,FileName from dbo.FilesToLoad) BEGIN Select FolderPath,FileName from dbo.FilesToLoad END ELSE BEGIN SELECT 'Not Exists' as FolderPath,'Not Exists' AS FileName END
Single Row result set is specified, but no rows were returned in Execute SQL Task - SSIS Package
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 Single Row Result Set in Execute SQL Task and Control the Flow Tasks by using that value ( Precedence Constraint 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 ( 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
Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. PSC Result 2019
ReplyDeleteThis is my first time i visit here and I found so many interesting stuff in your blog especially it's discussion, thank you. birre acide on line
ReplyDeleteVery good article! Your post is really helpful for me thanks for wonderful post.I am very happy to read your post Honours 4th Year Exam Routine Published 2020 Visit the website
ReplyDeletehttps://allresultbd.com/
ReplyDeleteThanks for your information about Chittagong university admission test and Dhaka university admission test can be the most demanded in Bangladesh with no information. However they want to know about Dhaka university admission test .
DeleteAdmittedly, this is a handy post. I have learnt some stylistics approach of web content writing. In addition, I can incorporate these techniques in my writing on Our Website given here. We spread rapid yet authentic news throughout the world. Thanks a lot for this post.
ReplyDeleteLet me begin by appreciating the author of this post. Admittedly, this is an effective post. I have learnt some stylistic approaches of web content writing. In addition, I can incorporate these techniques in my writing on Our Website given here. We spread rapid yet authentic news throughout the world. Thanks a lot for this post.
ReplyDeleteAloresultbd.com
ReplyDeletehttps://bangladeshresultbd.com/gst-admission-result-2020-21-www-gstadmission-ac-bd/
ReplyDeleteThanks for the platform using which we share our thoughts. See recent change in DSHE weekly assignment 2021 and share the way of measuring DSHE Assignment syllabus as well as we have come up with Class 7 assignment answer 4th week .
ReplyDeleteYou have a great post indeed. A good number of people want to know about HSC English Assignment Answer 2021. The percentage of the people knowing of Class 10 Assignment BGS has also been affected severely. Now, the students will also look for HP Laptop Price Bangladesh along with that of Class 9 Assignment 2021 Bangladesh. You have a great post indeed. A good number of people want to know about 41th BCS Result 2021. The percentage of the people knowing of Class 10 Assignment BGS has also been affected severely. Now, the students will also look for Class 10 2nd week assignment along with that of Class 8 Assignment 2021 Bangladesh.
ReplyDeletedefinitely outstanding You can do much better. But I still say it's perfect, the article is very knowledgeable.
ReplyDeleteสมัครสมาชิก 123betting