Error in send mail task

I have a script task in which I check the size of a file.

If the size of a file is greater then 0 KB then I need to send this file as an attachment using send email task.

If size is equal to 0 KB then I don't want to send email at all.

In the script task, I have a flag(@.sFileExists) which i set to true in case of size of file greater then 0 and false in other case.

I am using a precedance constraint (Expression : @.sFileExists=true) and condition is logical AND.

After script task based on the condition (@.sFileExists=true) I am using the send email task for sending the email.

But I am not receiving the email. Please sugest where I am wrong.

Please note that the send email task is working all-right separately.

Do you get any error?
Does the task gets executed at all (when debugging in BIDS - does it turn green)?

Error in send email task

I have a script task in which I check the size of a file.

If the size of a file is greater then 0 KB then I need to send this file as an attachment using send email task.

If size is equal to 0 KB then I don't want to send email at all.

In the script task, I have a flag(@.sFileExists) which i set to true in case of size of file greater then 0 and false in other case.

I am using a precedance constraint (Expression : @.sFileExists=true) and condition is logical AND.

After script task based on the condition (@.sFileExists=true) I am using the send email task for sending the email.

But I am not receiving the email. Please sugest where I am wrong.

Please note that the send email task is working all-right separately.

try ==

so (@.sFileExists==true

|||I tried this, it's not working|||hey its working now, i don't know what was wrong. I deleted the existing send email task and took the new one.

Error in Maintenance Plan (tempdb)

Hello
Give this error in Maintenance Plan:
8] Database openview: Removing unused space from the database files (if
database size is more than 50 MB). Reducing free space to 10 percent of
data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002:
[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for
database
'tempdb' is full. Back up the transaction log for the database to free up
some log space.
End of maintenance plan 'DB Maintenance Plan openview' on 13-07-2006 0:00:22
SQLMAINT.EXE Process Exit Code: 1 (Failed)
What should I do?
Regards
José Júlio DuarteYou need to clear the tempdb, There are few methods by which you can do
this
http://support.microsoft.com/defaul...kb;en-us;307487
"Jos Jlio Duarte" <JosJlioDuarte@.discussions.microsoft.com> wrote in
message news:59EC2548-AAB9-4456-9001-B326BC9756D4@.microsoft.com...
> Hello
> Give this error in Maintenance Plan:
> 8] Database openview: Removing unused space from the database files (if
> database size is more than 50 MB). Reducing free space to 10 percent of
> data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The log file fo
r database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space.
> End of maintenance plan 'DB Maintenance Plan openview' on 13-07-2006
0:00:22
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> What should I do?
> Regards
> Jos Jlio Duarte

Error in Maintenance Plan (tempdb)

Hello
Give this error in Maintenance Plan:
8] Database openview: Removing unused space from the database files (if
database size is more than 50 MB). Reducing free space to 10 percent of
data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002:
[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database
'tempdb' is full. Back up the transaction log for the database to free up
some log space.
End of maintenance plan 'DB Maintenance Plan openview' on 13-07-2006 0:00:22
SQLMAINT.EXE Process Exit Code: 1 (Failed)
What should I do?
Regards
José Júlio DuarteYou need to clear the tempdb, There are few methods by which you can do
this
http://support.microsoft.com/default.aspx?scid=kb;en-us;307487
"José Júlio Duarte" <JosJlioDuarte@.discussions.microsoft.com> wrote in
message news:59EC2548-AAB9-4456-9001-B326BC9756D4@.microsoft.com...
> Hello
> Give this error in Maintenance Plan:
> 8] Database openview: Removing unused space from the database files (if
> database size is more than 50 MB). Reducing free space to 10 percent of
> data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space.
> End of maintenance plan 'DB Maintenance Plan openview' on 13-07-2006
0:00:22
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> What should I do?
> Regards
> José Júlio Duarte