Hi!

As new to SSIS, I tried this. It worked fine to produce the html-presentations when doing this manually, but not in SSIS.(sql2008)

I did this ex on own data, and many problems came up.

How can I get SSIS to produce 'encoding="ISO8859-1" ' or like för special letters?

Bad characters Errors because SSIS produces "utf-8"

The XLS file only produces half of what was produced manually (drag/drop into explorer). I got the headline, or I got the rows without headlines / details.

I even tried to make a table as shown in the link (http://www.xmlfiles.com/xsl/), but compiler error in SSIS. I was not able to find out how to check this. Are there limits for XLS files in SSIS. This ex also works fine manually.

Next point was emailing.

I did not succed how to use the script för email. I copied the whole script inte SSIS, but no. Error messages in scripts are not for new beginners..

It would be nice to see the complete solution for how you did it?

It works with emailing using attachment, but the produced html file was no good...:):w00t:

Cheers

/Allan