The first thing I'd do is check the output - see if you're getting valid HTML that includes the images you want to see before this gets attached to or...

Updating a variable from an Execute SQL Task is pretty straightforward; choose your connection, enter your SQL command (in this case, any statement that returns one value, this being the...

Thanks for all the responses to the article, it's great to have so many people obviously take the time and trouble to read it properly and respond both here and...

I had the exact same problem with the same source (the 70-433 book CD), but found the fix here:

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/cd00c8cc-8ab0-4499-b968-5fefc9dcf553

"The fix to backup successfully, is to delete the...

Thanks very much for all the appreciative and useful comments. I'm afraid I don't have time at present to answer all the questions that have been asked - this article...

My pleasure, thank you very much for your kind comments.

Does calling other packages (that don't use the mailing functions) from SQL jobs work for you? In other words, is this the only SSIS job that doesn't work for you...

Do you mean that when you run the job manually it fails, or when it runs as scheduled (and thus using the permissions of the SQL Server Agent account?) that...

Hi Michael...sorry for the delay in replying.

Seeing the xsl file on it's own (without the relevant XML input) probably isn't going to be much help, but if you'd like I...

You'll need to do a bit of debugging. The first place I'd look is in the SQL statement that populates the varDeleteFileList variable; if you run this as a query...

Hi Michael, thank you very much.

Regarding your problem, have you defined the variables as specified in step 7? And does your SQL task use an *ADO.NET* connection? This last is...

Hi Alberto,

Funnily enough, there is a way of doing almost the same thing in SQL 2000, but the way you do it is completely different. I used to have...

Thanks, David...I wish I'd seen your excellent XSL article back when I was figuring out how to get all this working; it would have saved me a lot of time....

Thank you, sir! Glad to be of assistance.

It's included as an install option in SQL Server 2005 and SQL Server 2008, though not in the free Express or Compact editions.