Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / DTS / July 2008

Tip: Looking for answers? Try searching our database.

control flow vs data flow tasks

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 30 Jul 2008 01:24 GMT
I want to use SendMail task to send an email - only if data exists in table.

easy enough, however to check if data exists I have to go to data flow, how
do i return to control flow that data exists and yes - send an email?

tia,
chris
matteus - 30 Jul 2008 09:30 GMT
Hi Chris,

the best way to send mail only if the to-be-attached file isn't empty
is... not to create empty files... :) Have you considered such an
alternative?
Actually you don't need to be in data flow to check if data exists,
yes this can be easier performed in data flow, but with the script
task in control flow you could figure it out.
In fact I thought about Script Task, which you can use not only to
check for data inside the record but also to send the mail.
Through coding you can check and send only the most recent files, or
the files bigger than 0bytes...

HTH,
M.

> I want to use SendMail task to send an email - only if data exists in table.
>
[quoted text clipped - 3 lines]
> tia,
> chris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.