On the server where the package is running.

• This reply was modified 4 years, 4 months ago by Jeffrey Williams. Reason: Stupid phone

If you get the same message, then the driver isn't installed on the server.  Install the 74 bit driver.

Any triggers that could be rolling back the transaction?

The message is pretty clear - the OLE DB provider the package requires is not registered on the server.  When you develop on your workstation you are developing using a...

I would re-evaluate the code and remove any redundancy where possible.  For example, I often see someone perform an insert into a table (often a temp table) followed by multiple...

Instead of using LEAD or LAG you could use MIN/MAX/FIRST_VALUE/LAST_VALUE depending on requirements.  Or - you could define a default value to all null values.

Which one you use depends on...

Does this work?

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.DBMail.html

And last but not least, thank you for your unabashed comment on the certs.  I could go on a tear about them but I'll just leave it at that....

Yes - please show the full script/procedure.  This can and will help someone else and will be a good contribution to the community.

Small change - you need to use this:

 --==== Build the table data and return in the xmlResults variable
Declare @columnList varchar(max) = cast((Select concat(', coalesce(sum(Case When ft.Entity...

There were a couple of small mistakes in the header code I posted - here is the updated version:

 --==== Create the table header
 Select @tableHeader =...

If by row total - you mean an additional column at the end, then please review the thread I linked to in a previous message.  That code adds a totals...

This should get you close - you still need to build the rest of the HTML code but that all exists in the examples I linked to.

...

I looked at your earlier attempt - which doesn't look anything like the cross-tab examples.  Since you have not provided data in a consumable format (create/insert statements) it is really...

Yes - the totals are calculated using grouping statements and the pivot is done using FOR XML.  Or - you can pivot the data into a temp table and dynamically...