I have an Execute SQL Task that runs a simple SELECT query. I have the result set = Full Result Set. The variable is of type Object and the value is System.Oject. After successful completion of the Execute SQL Task, I am doing a Send Mail task. For the Message Source, I want to use this Object. The drop down is only listing variables of type String. Can you not use a variable of type Object in a Send Mail Task? If not, what is the easiest workaround? Thanks!
No, you can't use an object for the message source. You could use a column from the resultset, though. If you give more description on what you are trying to do, we'll be able to suggest some work arounds.
If you are trying to send the contents of the recordset in an email, here are a few posts that might help:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1768087&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1502762&SiteID=1
No comments:
Post a Comment