SSIS & SQL 2008 - Want to run a query and email addresses found in it's output
http://www.sqlis.com/sqlis/post/Shredding-a-Recordset.aspx This link above fixed my issue completly. (except now I'm having an issue with my SMTP connection relaying to outside domains but that's another issue). Thanks all!
June 27th, 2011 7:20pm

Hurst, 1) Try to debug the package using break points and the values can be checked during rumtime using locals in the Debug menu. http://msdn.microsoft.com/en-us/library/ms141754.aspx 2) I see same variables names are used for the object varaible and the varaible for the Email. Try using 2 different varaibles and check it out. Happy to help! Thanks. Regards and good Wishes, Deepak.
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 8:55am

Hurst, 1) Try to debug the package using break points and the values can be checked during rumtime using locals in the Debug menu. http://msdn.microsoft.com/en-us/library/ms141754.aspx 2) I see same variables names are used for the object varaible and the varaible for the Email. Try using 2 different varaibles and check it out. Happy to help! Thanks. Regards and good Wishes, Deepak. I can't see anything from the output since it's an object. I just see "system.object" in the local.
July 2nd, 2011 9:00am

I'm REALLY new to SSIS but am fairly capable with SSRS and SQL. I'm trying to run a query that is going to output a list of email addresses. I then want to send an email body that is constant to each of them (thank you for being a customer...) as well as a link to a survey. I've seen a couple of messages online that say how to do it but it's simply not working. This is what I have: Execute SQL Task - This runs my script against my production DB and returns only email addresses that match a set of criteria. 1 column of data but this could grow to more. I have the resultset as "full result set"and the result name as "EMail" (this matches my SQL Output heading) to "User::CustEMail" with a value set to Object. This points to a Foreach Loop Container. Foreach Loop Container is set to collection "Foreach ADO Enumerator" and the mode is "Rows in the first table" and the ADO object source variable is set to "User::CustEmail". The variable mappings have the User::CustEmail indexed at 0. Within this container is my "Send Mail Task". My send mail task has a yellow caution sign saying that "the address in the TO line is malformed...". I simply have the To field on the mail tab set to @[user:CustEmail] (I know this is wrong and am lost on what to do).
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 11:51am

Can you try giving a genuine value to variable CustEmail and check the result?Nitesh Rai- Please mark the post as answered if it answers your question
July 2nd, 2011 11:58am

The problem is a minor one. The variable you're using (CustEmail) doesn't have any value in it... yet. Since it doesn't have a value in it when you're designing your package, the Send Mail Task is complaining. Put your own email address in there (or a dummy one), and that will satisfy the Send Mail Task. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 12:21pm

The problem is a minor one. The variable you're using (CustEmail) doesn't have any value in it... yet. Since it doesn't have a value in it when you're designing your package, the Send Mail Task is complaining. Put your own email address in there (or a dummy one), and that will satisfy the Send Mail Task. Talk to me now on I started by designing my sendmail task first and just put constants in it... sends mail perfectly. It's like my SQL script runs perfectly and my sendmail runs perfectly but when the hip bone connects to the knee bone... well thing go awry so I would imagine my script is not passing the variables (or I don't know how to declare them) properly. /showing my SSIS greenness (great program though)
July 2nd, 2011 9:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics