Single Row result set is specified, but no rows were returned in Execute SQL Task in SSIS Package - SQL Server Integration Services (SSIS) Tutorial

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
  ( 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 

11 comments:

  1. 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

    ReplyDelete
  2. This 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

    ReplyDelete
  3. Replies
    1. Thanks 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 .  

      Delete
  4. Admittedly, 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.

    ReplyDelete
  5. Let 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.

    ReplyDelete
  6. https://bangladeshresultbd.com/gst-admission-result-2020-21-www-gstadmission-ac-bd/

    ReplyDelete
  7. Thanks 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

    ReplyDelete
  8. You 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.

    ReplyDelete
  9. definitely outstanding You can do much better. But I still say it's perfect, the article is very knowledgeable.
    สมัครสมาชิก 123betting

    ReplyDelete