options for generating report from ssrs

Question

hi we run 2016 enterprise. i am trying to follow links like https://www.sqlservercentral.com/articles/generate-ssrs-reports-from-a-ssis-package and https://www.codeproject.com/articles/675762/call-ssrs-reports-by-using-csharp to render a report from my package. in one link i see instructions to add a reference to a service but when i go down that road i see no option for the service (ReportExecutionService) referenced in that article. if i go down another road, i dont know which namespace to add to the script so rptviewer is known, but even if i find it, i'm not sure this is the path i want to follow if other authors are saying to add a reference to a service instead. my report is deployed to the server you see below. i did this years ago and dont believe i needed to add a reference to a service at that time.

Answer 1

i tried adding and even looking for a namespace called Microsoft.Reporting.Webforms in both assemblies and COM to no avail.

Answer 2

....and i'm lookin at this solution which appears to add byte by byte in a loop after rendering. at least the namespaces i have seem to allow for this solution. i may try to translate this to c# and see how it goes.

Answer 3

i'm trying to convert the vb at https://www.mssqltips.com/sqlservertip/3475/execute-a-sql-server-reporting-services-report-from-integration-services-package/ into c# and have gotten pretty far but even with a cast and even following the c# recommendations, the line i'm pointing to in red wont convert to c#...

Answer 4

...and i got past that problem, will try running this now.

not sure about the credentials attributes.

I'm guessing this overall approach is an older way of doing this from before the time the service mentioned earlier was available. and who knows why i couldnt get the report viewer approach to work, ie why the namespac its supposed to be in seemingly isnt available in my list of .net and COM items.