go to Database mail from Object Explorer ==> Configure Database mail ==> Manage database mail accounts and profiles.

Vijayraj.

Thanks all for the reply...

while configuring the account on my sql server i have set the "server name" in SMTP properties as

from there it works properly. and i...

Database mail i m using from so long and it is working fine.

but when i try to use Send Mail Task of SSIS.

It ends with following error on execution:

"Error: 0xC002F304...

you can use xp_cmdshell to run the Dir command on that folder. here you need to do some extra work to separate the filenames from the output of dir...

Thanks for the reply.

i m succeded with DTExec command.

But not aware of how to use SSIS object model.

I need to get the unitwise output into SEPARATE EXCEL FILES with file name as unit name. Hence, SSIS should generate multiple excel files as per the parameter table units.