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 

25 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
    Replies
    1. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Project Centers in Chennai

      Delete
  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. 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
  5. 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
  6. 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
  7. 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
  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. Bangladesh Education Board Result : PSC Result , SSC Result, HSC Result, CBSE Result, Honours Result, Masters Result published on our Government Official website: https://allresultsall.com

    ReplyDelete
  12. https://hitresultbd.com/ssc-result-2021-bangladesh-all-education-board-result/

    ReplyDelete
  13. 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
  14. 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
  15. 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
  16. https://bangladeshresultbd.com/gst-admission-result-2020-21-www-gstadmission-ac-bd/

    ReplyDelete
  17. 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
  18. 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
  19. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

    ReplyDelete
  20. Thank you so much for this Post and all the best for your future. You are really a talented person I have ever seen. I am satisfied with the arrangement of your post. I have also shared some useful links.
    May intake 2022
    study abroad
    AIMS Education
    how to send photos on tinder

    ReplyDelete
  21. Hello Everyone,

    Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS

    Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com

    Services rendered include:

    * Refinancing Loans
    * Car Loan
    * Truck Loans
    * COVID-19 Financing Loan
    * Home Loan
    * Mortgage Loan
    * Debt Consolidation Loan
    * Farm Loan
    * Business Loan [secure and unsecured]
    * Personal Loan [secure and unsecured]
    * Students Loan and so many others.

    For more info; Contact us via Email: profdorothyinvestments@gmail.com

    With Prof. Mrs. DOROTHY LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic

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

    ReplyDelete