Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kma07
Starting Member
3 Posts |
 Posted - 2010-07-14 : 00:36:19
|
| Hi everyoneI'm fairly new to this.I want to write a store procedure so I can email users.There will be a file in this format: MYFILE.john.doe@email.com.XMLthat is uploaded by the user to a directory.Now I need to have a procedure to read the john.doe@email.com part and email the file to that email address using sendmail.I hope that makes sense.If anyone can help it would be greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kma07
Starting Member
3 Posts |
Posted - 2010-07-14 : 01:55:40
|
| Oh it was suggested that I create a stored procedure to do all this.SSIS? To be honest, I wouldn't even know where to start |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
stored procedure accessing file system?