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 

12 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. DPE Result 2020 (Directorate of Primary Education) will publish in the last week in April 2020! That’s Attractive and Great news for all DPE Examinee and Their Guardians. The Education Board of Bangladesh and the honorable chairman has announced that they’ll publish the DPE Result 2020 as soon as possible and it will be the last week of coming April. A large Number of DPE Examine and other People don’t know how to check SSC Result 2020 Fast. PSC Scholarship Result 2020 will available on Education Board Official Website, Teletalk Result Website and also on PEC/ Ebtedayee Scholarship Result 2020. Check from this Website now.
    If you are reading this post, don’t worry about checking SSC Exam Result 2020. Here are the complete Information and Guideline about SSC Result 2020 of All Education Board Bangladesh.

    National University Admission Authority has been published NU Degree 3rd Year Result 2020 Pdf Download (Session 2015-16) on the official website today. Now you can check it from here.

    ReplyDelete
  4. DPE Result 2020 (Directorate of Primary Education) will publish in the last week in April 2020! That’s Attractive and Great news for all DPE Examinee and Their Guardians. The Education Board of Bangladesh and the honorable chairman has announced that they’ll publish the DPE Result 2020 as soon as possible and it will be the last week of coming April. A large Number of DPE Examine and other People don’t know how to check SSC Result 2020 Fast. PSC Scholarship Result 2020 will available on Education Board Official Website, Teletalk Result Website and also on PEC/ Ebtedayee Scholarship Result 2020. Check from this Website now.
    If you are reading this post, don’t worry about checking SSC Exam Result 2020. Here are the complete Information and Guideline about SSC Result 2020 of All Education Board Bangladesh.

    National University Admission Authority has been published NU Degree 3rd Year Result 2020 Pdf Download (Session 2015-16) on the official website today. Now you can check it from here.

    ReplyDelete
  5. SSC Routine 2020 (Secondary School Certificate Exam Routine 2020) has been publish on the last month 2019! That’s Attractive and Great news for all SSC Examinee and Their Guardians. The Education Board of Bangladesh and all Education Board chairman has announced the SSC New Routine 2020 on last month. A large Number of SSC Examine and other People don’t know how to check SSC Routine 2020 Fast. The Education Board authority also published HSC Routine 2020 on their official website. Now you can see the HSC New Routine 2020 quickly.
    There are another good news for the National University Students of Bangladesh that the NU Degree 2nd Year Routine 2020 PDF Download has been published on the official website today.

    ReplyDelete
  6. DSS & DNC Job circular has been published by the Bangladesh government. The New Exam date of DSS Job 2020 has been published by the authority on their official website today. Now you can check it from here. DNC Authority also published a new job circular on their official website today. Now you can check DNC Job Circular 2020 from here.

    You can also visit another option if you need it. In Bangladesh there is an exam is going to start from 1 February 2020. That named SSC Exam. We have made a suggestion for the exam you can check this SSC Suggestion 2020 from here.

    BB Combined 7 Bank 771 Posts Job Circular 2020 PDF Download

    BREB Job Circular & Online Application 2020 PDF Download

    ReplyDelete
  7. DSS & DNC Job circular has been published by the Bangladesh government. The New Exam date of DSS Job 2020 has been published by the authority on their official website today. Now you can check it from here. DNC Authority also published a new job circular on their official website today. Now you can check DNC Job Circular 2020 from here.

    You can also visit another option if you need it. In Bangladesh there is an exam is going to start from 1 February 2020. That named SSC Exam. We have made a suggestion for the exam you can check this SSC Suggestion 2020 from here.

    BB Combined 7 Bank 771 Posts Job Circular 2020 PDF Download

    BREB Job Circular & Online Application 2020 PDF Download

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

    ReplyDelete
  9. Very 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

    ReplyDelete
  10. Very 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

    ReplyDelete
  11. Very 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

    ReplyDelete
  12. Very 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

    ReplyDelete