Discussion:
SSIS Package: exit with success if no data is select
(too old to reply)
qjlee
2008-11-13 15:54:03 UTC
Permalink
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,
Todd C
2008-11-13 19:28:34 UTC
Permalink
Are you using DTS and SQL 2000 or SSIS and SQL 2005 (or even SQL 2008?)
--
Todd C
Post by qjlee
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,
qjlee
2008-11-14 01:57:24 UTC
Permalink
I am using SQL 2005.

Thanks,

Qjlee
Post by qjlee
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,
Loading...