Solved

SSIS visual or pop up nitification or dialog window

Posted on 2015-01-16
3
99 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 14

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now