Not sending an Empty File 1

[klewis10367]

I e-mail an error report through a dts package but sometimes the report is empty. How can I tell the dts package not to send the e-mail. I am new to dts so if you could explain it as easily as possible. Thanks.

 

[SQLDenis]

declare @count int
select @int count(*) from table .... (same query as whatever populates the file)
if @count <> 0
begin
send mail
end

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[klewis10367]

I hope this doesn't sound stupid, but do I put this in an execute sql task in the dts package.

 

[SQLDenis]

you can like this

declare @count int
select @int count(*) from table .... (same query as whatever populates the file)
if @count <> 0
begin
exec master..xp_sendmail ...etc etc etc
end

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[klewis10367]

When I run this code I get the following Error:

Must declare the variable '@int'.

 

[SQLDenis]

Oops typo should be

declare @count int
select @count =count(*) from table .... (same query as whatever populates the file)
if @count <> 0
begin
exec master..xp_sendmail ...etc etc etc
end

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[klewis10367]

Thanks, that worked.