Can you provide a hint to the solution?

Rendering as web or rendering as PDF?

Have you tried a textual dump of the offending field to see what value might give the error?

SELECT dateasstring from openquery(progresssource,'select tostring(offendingfield) dateasstring ...') progress


Glad you found it.
Thanks for the solution

I don't use SSAS yet but Have you looked at the logs?
Following link is a bit old but might still be relevant
CU7...

All the packages of the project are checked out?

Does the statement work outside sql server agent? It might be a permission problem.
You can run sql agent jobs under a different windows account using proxies and credentials

spid= connection id, usually < 50 are system connection.
About your memory error, it is mentioned in de MS docs Resolve page allocation failures due to insufficient memory...

PASS is a bit far but in Belgium I recommend Dataminds Connect (previously sql server days).
Enjoying the precon for the in-depth training about a specific topic, and the next...

Latest is best
Fond memories of SQL 2012 with the introduction of analytic functions

At work we did it parameterising the Connection property of the package-level OLEDB connector (which allows parameterisation)
MyProcessingFile is set with the for-each iterator
Connectionstring

"Data Source=" + @[User::MyProcessingFile]...

in memoriam. Didn't know Robert but he wrote good blogs.

Looks like the data-driven subscription functionality
https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions

Testing spring cleanup subscriptions. We're getting 10+°C in wintertime

Trace command on the source why it takes so long? Play with decreasing/increasing buffer sizes