Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 736
  • Last Modified:

SEND Email via DTS Package

I want to create a dts package that will run a query to acquire the email addresses.  I then want to email these people a message. The addresses can change, but the Subject and Message of the email will pretty much be the same. This is my first time working with DTS Packages. I'm not sure the best way to go about this?
0
slrine2000
Asked:
slrine2000
  • 3
1 Solution
 
slrine2000Author Commented:
I'm trying this:
Exec master.dbo.xp_Sendmail @recipients  = @mailTo, @copy_recipients = @mailCC,
@subject = @mailSubject, @message = @mailBody, @user='dbo'

However I'm getting this error: xp_sendmail: Invalid parameter '@user'
In help it says the parameter should be @set_user but if I try that then it says parameter @user is required.
Any ideas?
0
 
slrine2000Author Commented:
Disregard last post, I got it to work. I didn't have the SQL Service running with a valid account. I also removed the @user and it worked.
0
 
slrine2000Author Commented:
Thanks for pointing me in the right direction
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now