Solved

SSIS visual or pop up nitification or dialog window

Posted on 2015-01-16
3
118 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

691 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