Solved

SSIS visual or pop up nitification or dialog window

Posted on 2015-01-16
3
103 Views
Last Modified: 2016-02-15
Hello
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
0
Comment
Question by:Rayne
  • 2
3 Comments
 

Author Comment

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

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40554934
Hi,

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

Author Closing Comment

by:Rayne
ID: 40562338
thank you Vikas
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Outlook Free & Paid Tools
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

809 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