Viewing 4 posts - 1 through 4 (of 4 total)
Now its working i juz changed connection to OLEDB earlier i selected ADO.NET
Thanq Bang for all ur replies it was very helpfull
Now its working
October 30, 2008 at 11:48 am
yes i created profile name kalyan its working fine i even sent test mail n got that test mail
but i'm trying to do it from SSIS execute sql task it...
October 30, 2008 at 11:10 am
when i use sp_send_dbmail its working fine
but i want to do it with send mail task
so can u please tell me how to give rights to sql server so...
October 30, 2008 at 9:57 am
Thanq crozyroc for your prompt reply
i'll try that script and let you know whether it worked or not
October 30, 2008 at 9:04 am
Viewing 4 posts - 1 through 4 (of 4 total)