I need to execute a select statement in a send mail task in SSIS. I can send regular emails using this task, but is is possible to send a select statement through? I have tried xp_sendmail, but we are not allowed to turn this feature on, and I have
tried reporting services, but the service is not installed. Lots of road blocks... LOL
If this is not possible, please recommend an alternative...
Any help would be appreciated
Dave SQL Developer
View Complete Post