Look into BOL for XP_SendMail. There is a parameter for attachment. Just give your file name (complete path) to this. in @recipients parameter write e-mail id whom u want to...

Read Kimball's, The Data Warehouse ETL Toolkit. Very good ref book.

Yes it is possible. You might need to map the network dirve. Use sendMail task of DTS or XP_Sendmail sp.

If you have relevant persons of some windows group, you can...

Good Work Andy!

Excellent articel. Pl. give some documentation about your procedure...

Good Article

Are you reading any parameters from file stored on your local/network drive from DTS package?