dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

SSIS Package: exit with success if no data is select - sqlserver-dts

This is a discussion on SSIS Package: exit with success if no data is select - sqlserver-dts ; I have a table called MemberRnrollment, which contains two columns, EnrollmentDate and Enrollee. I need to create an SSIS to send me the total number of Enrollee for each date. If there is no Enrollee, then do not send me ...


Home > Database Forum > Microsoft SQL Server > sqlserver-dts > SSIS Package: exit with success if no data is select

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-13-2008, 11:54 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default SSIS Package: exit with success if no data is select
I have a table called MemberRnrollment, which contains two columns,
EnrollmentDate and Enrollee.

I need to create an SSIS to send me the total number of Enrollee for each
date. If there is no Enrollee, then do not send me any email.

Can somebody tell me how to do that?

Thanks,


Reply With Quote
  #2  
Old 11-13-2008, 03:28 PM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default RE: SSIS Package: exit with success if no data is select
Are you using DTS and SQL 2000 or SSIS and SQL 2005 (or even SQL 2008?)

--
Todd C


"qjlee" wrote:

> I have a table called MemberRnrollment, which contains two columns,
> EnrollmentDate and Enrollee.
>
> I need to create an SSIS to send me the total number of Enrollee for each
> date. If there is no Enrollee, then do not send me any email.
>
> Can somebody tell me how to do that?
>
> Thanks,
>
>
Reply With Quote
  #3  
Old 11-13-2008, 09:57 PM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default RE: SSIS Package: exit with success if no data is select
I am using SQL 2005.

Thanks,

Qjlee

"qjlee" wrote:

> I have a table called MemberRnrollment, which contains two columns,
> EnrollmentDate and Enrollee.
>
> I need to create an SSIS to send me the total number of Enrollee for each
> date. If there is no Enrollee, then do not send me any email.
>
> Can somebody tell me how to do that?
>
> Thanks,
>
>
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 09:00 AM.