I think that you might have to split things up, such that one of the two different versions of the T-SQL is executed, depending on SQL Server version.

If you're not...

Hello everyone,

I hope I'm in the right place here. If not, please let me know where I can post this question.

Here's my question:

With this call dtsRuntime.Package package = app.LoadPackage(Etl_package,...

I meant it merely as a diagnostic tool, not a permanent change. But taking out the dirty reads sounds like a good idea too.

Are you using a third-party library to convert PDF to Excel? If not, how are you doing it?

Have you considered redirecting error rows to an error table, rather than simply failing the package? This could help you track down what's happening.

Sounds like you've...

Is the version of SQL Server the same on the local machine and the server?

Can the column in the source table ever be null?

DECLARE @sql VARCHAR(MAX);

SELECT @sql
    = STRING_AGG (
                 ...

This still sounds like an ASP.NET question. Why do you think that this is a SQL Server problem?

thanks phil, do you mean all on the same single pc?   That's the kind of feedback i was hoping for.   That way no one instance of sql could interfere...

Have you considered using multiple local VMs, one per project?

Not sure what your question is, please elucidate.

This is exactly what I was thinking, too.

What do you mean by the 'SSISDB category'?