When a record is inserted, I need to export the data to a text file and email it. I tried using xp_sendmail with @attach_results set to true, but, the text file is not in a data format. Then, I used DTS to export the data which turned out well, but I cannot figure out how to do this on the fly. Is there some code I can put in an insert trigger to do this? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export to Text File on Insert
- Thread starter stacy47
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
