SSIS visual or pop up nitification or dialog window

Posted on 2015-01-16
Medium Priority
Last Modified: 2016-02-15
Is there something in ssis job that I can add so that  - first it queries a table and if the query returns at least one or more row results, then just do a pop up in the screen saying “no can do”
How do I add such a visual check or anything similar while running a SSIS job. It’s a way to validate that the raw data is good.

Thank you
Question by:Rayne
  • 2

Author Comment

ID: 40554578
users will be running that ssis job daily
LVL 15

Accepted Solution

Vikas Garg earned 2000 total points
ID: 40554934

You can have send mail task in ssis which you can enable by checking value of the variable

The row count of the table will be stored in the variable.

You can have the show message box in script task but that will only be visible while you are performing the task in BIDS but when it is scheduled as job that pop us will not be visible.

Author Closing Comment

ID: 40562338
thank you Vikas

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question