Sharing knowledge does not lessen your store, often it gets you more.
Success doesn't happen overnight and patience is key to living your dream life.
Success is a journey not a destination
Single row result set is specified but no rows were returned
If you try to execute a SQL query in SSIS with the resultset as 'single row' and if your query doesn't return any records then you will get this error.
Solution
IF NOT EXISTS (Query Here)
SELECT ''
ELSE
Query Here
No comments:
Post a Comment