hi you have to configure smtp connection for that if you have your company mail id then you can do that easily, from database mail or from sql mail ....

goto business development studio.... then open new integration service project in toolbox you will found send mail task .... now first create your package and in between put this task...

yeh i am also thinking that you must split procedure , because reason is that you have so many if condition in to that. so there is rare chance to...

hi yes ofcourse there is a way to send mail notification when your package failed, goto business development studio , open your dts package there from their you can set...

Hi paresh this is raj i got the way you can get the answer of true or false

like if you enter wrong spelling word then it will check and tell...