"obviously replacing the params with the actual values"
do you mean

SELECT *
FROM  A
where col1=@param1

with

SELECT *
FROM  A
where col1=1

or you could use the oracle to_date function

AND SLD.docenimerosisdate >='02/02/2018'
AND SLD.docenimerosisdate >=TO_DATE('02/02/2018','DD/MM/YYYY')


I've only used PDF for exact layouts. Does it "print" correctly there?
Have you played around with HTML device settings html-device-information-settings

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.